Capgemini interview question

SQL Scripting concepts like ctes, subqueries, joins