Introduction
ROWS
RANGE
Default window frame
Instruction
Okay! It's your turn to write a query!
Here is a syntax reminder:
SELECT
Id,
Quantity,
ChangedDate,
SUM(Quantity) OVER(ORDER BY
ChangedDate ASC ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS SumQuantity
FROM StockChange
Exercise
For each order, show its Id, the PlacedDate, and a third column, which will count the number of orders up to the current order, when sorted by PlacedDate. Name this column OrderNumber.
Stuck? Here's a hint!
Sort the rows by PlacedDate inside the OVER() parentheses. Then introduce the keyword ROWS and use the BETWEEN ... AND ... construction.
