Write a SQL query to: [describe data need]. Based on this database structure: [describe tables/relationships]. Include JOINs if needed, proper filtering, meaningful column aliases, and ORDER BY for results. Add comments explaining each part of the query.