S&P Global Interview Question

basic oracle questions joins