Question d’entretien chez Groupon

How to optimise SQL query to run faster?