MSD interview question

Basic querys on sql based on select, order, group by