Pergunta de entrevista da empresa ST Engineering

SQL subquerying on a few different table, ranking.