Complex SQL Queries
hardNot StartedDescription
Write SQL queries for a given dataset.
Requirements
•Aggregation with GROUP BY and HAVING
•Subqueries and CTEs
•Window functions
•Multi-table JOINs
Requirements
- ▸Use window functions
- ▸Use CTEs
- ▸Multi-table JOINs
Acceptance Criteria
- ☐All queries return correct results
- ☐Queries are optimized
Sandbox