Pergunta de entrevista da empresa KRAN

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