Question d’entretien chez Yahoo

How would optimize a SQL select query?