Capgemini Interview Question

Oops concepts SQL queries