Describe your experience writing advanced SQL queries. Can you give an example of a particularly complex query you had to write?