Adenza interview question

Q: Asked about SQL queries