sql_window_6.sql

CREATE TABLE Sales (
    SaleID INT AUTO_INCREMENT PRIMARY KEY,
    ProductID INT,
    SaleDate DATE,
    QuantitySold INT,
    SalesAmount DECIMAL(10, 2)
);

INSERT INTO Sales(ProductID, SaleDate, QuantitySold, SalesAmount) 
VALUES
(1, '2023-01-01', 10, 100),
(2, '2023-01-01', 5, 50),
(3, '2023-01-01', 15, 20),
(1, '2023-01-02', 15, 150),
(2, '2023-01-02', 7, 70),
(1, '2023-01-03', 12, 120),
(2, '2023-01-03', 6, 60),
(3, '2023-01-03', 16, 30);