Pregunta de entrevista de WooliesX

It was around SQL and case studies. How to optimise SQL queries?