Question

Imagine you have an Inventory table with product_id and quantity columns. Write an Oracle SQL query to find the products that have experienced an increase in quantity compared to the previous month.

Answer 1

SELECT product_id

FROM (

    SELECT product_id, quantity, LAG(quantity) OVER (ORDER BY month) AS prev_quantity

    FROM Inventory

)

WHERE quantity > prev_quantity;