Pergunta de entrevista da empresa Unilever

How would you optimize the performance of a SQL query?