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,
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.