BNP Paribas Interview Question

Finally exception handling,Joins I'm SQL and oops concept.