How Much More Did They Order?
Tables Used
orderdetails
ColumnType
orderdetailidbigint
orderidbigint
productidbigint
quantitybigint
unitpricedouble precision
currencyidbigint
orders
ColumnType
orderidbigint
customeridbigint
orderdatetimestamp without time zone
totalamountdouble precision
statustext
Expected Output
Column
productid
orderdate
quantity
previousquantity
quantitychange

6. How Much More Did They Order?

Track changes in quantity across each product's order timeline.

Xorthax wants to analyze purchasing patterns. For each Product ID, calculate the change in order quantity compared to the previous order (as determined by order date).
Write Your Query