What’s the most complex SQL query you’ve written? Walk me through what it did, the key concepts involved, and the types of joins you used.