Context
This project showcases advanced SQL work on public datasets available in BigQuery.
Demonstrated skills
- Window functions: ROW_NUMBER, RANK, LAG, LEAD, SUM OVER
- Recursive and non-recursive CTEs
- Query optimization: EXPLAIN, partitioning, clustering
- Advanced aggregations: GROUPING SETS, ROLLUP
- Anti-joins and correlated subqueries
Tech stack
SQL · BigQuery · Google Cloud Platform
Results
(To be completed when the project is fully published)