CMIC interview question

Performance tuning SQL queries