Groupon Interview Question

How to optimise SQL query to run faster?