Pregunta de entrevista de Apple

How would you optimize SQL queries.