Deloitte interview question

Write one sql query by giving one scnerio