SEON interview question

How to optimise SQL queries?