SQL Practice: Window Functions

Test your knowledge of Window Functions in SQL with five challenges.

Introduction

• Try your SQL programming skills
• What you should know
• Explore the lab environment

1. Code Challenges

• 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

Conclusion

• Next steps