HARMAN Interview Question

Query optimization in SQL server