Astek interview question

Best ways to optimize an SQL query