Shopee Interview Question

How would you optimise a certain sql query?