S&P Global interview question

Basic sql query questions on aggregation and joins