Pregunta de entrevista de KRAN

Sql join query, sql select query with distint, orderby and groupby