Centric Consulting interview question

Sql query optimization