From the course: Advanced SQL – Window Functions
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Challenge: Aggregate window functions - SQL Tutorial
From the course: Advanced SQL – Window Functions
Challenge: Aggregate window functions
- [Instructor] I created challenges for chapters four, five, and six of this course. You will find the challenge requirements, guidelines, and the expected results in the code files for each chapter. In the same folder, you will find a file with my suggested solution, which I'm going to walk you through in the following video. I've contemplated the challenges' difficulty level for a while and it was not an easy decision. On one hand, a challenge that is too difficult will require much effort and may discourage you. On the other hand, a trivial one kind of misses the whole point of a challenge and for me, solving a tough challenge is one of the most rewarding experiences of SQL. And the more time and effort I need to invest in it, the greater the reward. This is an advanced SQL course, so I decided to lean slightly towards the more difficult side of the spectrum. Please let me know your feedback in the Q and A…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.