WooliesX interview question

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