MSD Interview Question

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