Deskpro Interview Question

How do you optimise SQL queries?