J.P. Morgan Interview Question

They asked me about SQL and the difference between IN and OUT join, also left and right out join. And some basic OOP and DS.