Broadridge interview question

All concepts in SQL. Mainly performance tuning and dynamic SQL