Practice SQL Window Functions | Xorthax's Trading Post

Tables Used

inventory

Column	Type
inventoryid	bigint
productid	bigint
quantityavailable	bigint
location	text
lastrestocked	text

products

Column	Type
productid	bigint
name	text
description	text
category	text
price	double precision
supplierid	bigint
stockquantity	bigint

suppliers

Column	Type
supplierid	bigint
name	text
originplanet	text
contactinfo	text
rating	double precision

Expected Output

Column
productid
category
totalstock
stockrank
differencetonext

74. Inventory Stack Ranks

Rank products by stock level and compute the difference from the next product.

Xorthax wants to track inventory trends. Write a query to calculate the rank of products by stock level and find the difference between the current and the next stock levels.

Write Your Query