Kickdrum Interview Question

How a SQL query can be tuned for better performance? (Not exactly this, but on similar lines)