Pregunta de entrevista de Shopee

How would you optimise a certain sql query?