SEON Interview Question

How to optimise SQL queries?