CREATE TABLE Products (
    ProductID INT PRIMARY KEY,
    ProductName VARCHAR(50),
    Price DECIMAL(10, 2),
    Stock INT
);

CREATE TABLE Orders (
    OrderID INT PRIMARY KEY,
    ProductID INT,
    Quantity INT,
    OrderDate DATE,
    FOREIGN KEY (ProductID) REFERENCES Products(ProductID)
);
INSERT INTO Products VALUES (1, 'Laptop', 75000.00, 10);
INSERT INTO Products VALUES (2, 'Mouse', 500.00, 100);
INSERT INTO Products VALUES (3, 'Keyboard', 1000.00, 50);

INSERT INTO Orders VALUES (1, 1, 2, '2024-12-01');
INSERT INTO Orders VALUES (2, 2, 5, '2024-12-02');
INSERT INTO Orders VALUES (3, 3, 1, '2024-12-02');
select * from products;
select * from orders;
UPDATE Products SET Price = 80000.00 WHERE ProductID = 1; 
select * from orders;
DELETE FROM Products WHERE ProductID = 3; 
select * from orders;

SELECT SUM(Stock) AS TotalStock FROM Products;
select * from products;
SELECT AVG(Price) AS AveragePrice FROM Products;
SELECT MAX(Quantity) AS MaxOrderQuantity FROM Orders;
SELECT MIN(Quantity) AS MaxOrderQuantity FROM Orders;