Pregunta de entrevista de Yahoo

How would optimize a SQL select query?