Describe a complex SQL query you wrote recently. What joins did you use, and how did you optimize its performance?
