HCLTech interview question

How to optimize an SQL query