From the course: Advanced SQL – Window Functions

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Challenge: Offset window functions

Challenge: Offset window functions - SQL Tutorial

From the course: Advanced SQL – Window Functions

Start my 1-month free trial

Challenge: Offset window functions

- [Instructor] Like the previous challenge, the last challenge for this course involves more than just the chapter's topic. So, of course, you will need to use offset window functions, but perhaps also aggregate functions or maybe even a RANK window function. Basic knowledge of datetime function is necessary, so if you're not familiar with these, the documentation is your friend. And please do read the requirements carefully. I left an important tip for you there that is going to save you some misery. Enjoy.

Contents