Capgemini Interview Question

sql - questions related to joins, like, having clause, temp table oops concept.