Capgemini Interview Question

SQL joints and some programming questions