Question d’entretien chez Ski-Pic

Given a certain table, how you would optimize the SQL query.