Astek Interview Question

Best ways to optimize an SQL query