NIKE Interview Question

How to optimize a SQL query?