Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Window Functions

Introduction
ROWS
7. First exercise
RANGE
Default window frame
Summary

Instruction

Okay! It's your turn to write a query!

Here is a syntax reminder:

SELECT
  id,
  quantity,
  changed,
  SUM(quantity) OVER(
    ORDER BY changed
    ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)
FROM stock_change

Exercise

For each order, show its id, the placed date, and the third column which will count the number of orders up to the current order when sorted by the placed date.

Stuck? Here's a hint!

Within the parentheses of OVER(...), sort the rows by the placed date. Then, introduce the keyword ROWS and use the BETWEEN ... AND ... construction.