Pregunta de entrevista de ST Engineering

SQL subquerying on a few different table, ranking.