Cummins Interview Question

SQL Join Query between 2 tables