Practice SQL Window Functions | Xorthax's Trading Post

Tables Used

orders

Column	Type
orderid	bigint
customerid	bigint
orderdate	timestamp without time zone
totalamount	double precision
status	text

orderdetails

Column	Type
orderdetailid	bigint
orderid	bigint
productid	bigint
quantity	bigint
unitprice	double precision
currencyid	bigint

Expected Output

Column
orderid
orderdate
currencyid
rollingcurrencycount

14. Currency Trends in 7-Order Windows

Track how many currencies are used across each rolling window of 7 orders.

Xorthax is analyzing the diversity of galactic currencies used at his trading post. For each order, compute the number of currencies (by ID) used in the current 7-order window, ordered by order date.

Write Your Query