From the course: Complete Guide to SQL for Data Engineering: from Beginner to Advanced
Join today to access over 24,800 courses taught by industry experts.
Challenge: Find out the sum - SQL Tutorial
From the course: Complete Guide to SQL for Data Engineering: from Beginner to Advanced
Challenge: Find out the sum
(lively music) - [Instructor] Let's find out the cumulative sales volume of each product over the time. Now, understand, the cumulative sales volume means we are seeing here the cumulative sales volume would be like the running total of your quantity for each product ID and that you have to do based on your order timestamp column. Let's do that.
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.
Contents
-
-
-
-
-
-
-
-
(Locked)
Introduction to analytical functions5m 31s
-
(Locked)
Using the RANK() function7m 16s
-
(Locked)
Using the DENSE_RANK() function4m 27s
-
(Locked)
Exploring the ROW_NUMBER() function6m 35s
-
(Locked)
Understanding the LAG() and LEAD() functions7m 55s
-
(Locked)
Running totals with SUM() OVER()7m 29s
-
(Locked)
Calculating moving averages7m 33s
-
(Locked)
Challenge: Find out the sum33s
-
(Locked)
Solution: Find out the sum44s
-
(Locked)
-
-
-
-
-
-
-