Pergunta de entrevista da empresa Ski-Pic

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