Accenture interview question

sql server question. like CTE, Indexing, joins etc etc