Capgemini Interview Question

SQL Scripting concepts like ctes, subqueries, joins