Deloitte Interview Question

Write one sql query by giving one scnerio