CRISIL Interview Question

Inner Join, Left Join, Basic Aptitude question