Deloitte interview question

Write two queries using the SELECT