S&P Global interview question

basic oracle questions joins