Ski-Pic interview question

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