Test your knowledge of Window Functions in SQL with five challenges.
Overview
Syllabus
Introduction
- Try your SQL programming skills
- What you should know
- Explore the lab environment
- Solution: Calculate a running total
- Solution: Summarize weekly pay by department
- Solution: Rank department employees by pay
- Solution: Compare order totals over time
- Solution: Moving average
- Next steps
Taught by
Scott Simpson