Deloitte interview question

7) write sql query to select rows from table