Test your knowledge of Window Functions in SQL in this edition of Code Challenges. Instructor Scott Simpson provides five challenges—and his solutions—that reflect real-world data analysis use cases, including calculating a running total, ranking employees of a company by pay, and comparing order totals over time. It’s a data-driven world, and SQL is the language often used to work with that data. Try out Scott’s challenges to see how your skills match up, learn new methods, and gain confidence in working with the various data analysis and reporting tools that many SQL-compatible relational database management systems provide.