Shopee interview question

How would you optimise a certain sql query?