NIKE interview question

How to optimize a SQL query?