Learn Practice Projects Free datasets Resources Toolkit Pricing

Log in Start free

Loading…

Hands-on analytics engineering training with browser-based practice, guided projects, and a human-reviewed capstone.

support@analyticsengineering.com

Learn

The course
Roadmap
Practice
Projects
Free datasets
Resources
Templates
Open-source toolkit
Jobs
Job market data
Guides
Glossary
Compare tools
Starting-point quiz

Topics

Analytics Engineering
SQL
dbt
Data Modeling
BigQuery
Snowflake
Looker
Python
Career
Interview Prep

Company

About
1-on-1 coaching
Pricing
Log in
Start free

© 2026 Analytics Engineering · All rights reserved

Terms Privacy Built by Routeless

SQL: Window Functions

SQL: Window Functions

10 exercises·3 free

01Basic ROW_NUMBER
Free→
02Ranking Orders By Amount
Free→
03Partition By Category
Free→
04Running Total Of Orders
Locked→
05Running Count Of Customers Joined
Locked→
06Dense Rank By Department Salary
Locked→
07Percent Rank
Locked→
08Ntile Bucketing
Locked→
09Running Average Of Product Prices
Locked→
10Partitioned Running Total
Locked→