inventory.sql

CREATE TABLE InventoryStatus (
    ProductID INT,
    StatusDate DATE,
    InStock BOOLEAN
);

INSERT INTO InventoryStatus (ProductID, StatusDate, InStock) VALUES
(1, '2024-06-25', 1),
(1, '2024-06-26', 1),
(1, '2024-06-27', 0),
(1, '2024-06-28', 0),
(1, '2024-06-29', 1),
(1, '2024-06-30', 1),
(2, '2024-06-25', 0),
(2, '2024-06-26', 0),
(2, '2024-06-27', 1),
(2, '2024-06-28', 1),
(2, '2024-06-29', 1),
(2, '2024-06-30', 0);