Groupon interview question

How to optimise SQL query to run faster?