From the course: Advanced SQL – Window Functions
Join today to access over 24,800 courses taught by industry experts.
Challenge: Offset window functions - SQL Tutorial
From the course: Advanced SQL – Window Functions
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.
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.