Pergunta de entrevista da empresa S&P Global

Basic sql query questions on aggregation and joins