-- first table............................
CREATE TABLE products (
    ProductID INT PRIMARY KEY,
    ProductDescription VARCHAR(255),
    Price DECIMAL(10, 2)
);

INSERT INTO products (ProductID, ProductDescription, Price)
VALUES
    (1, 'Laptop', 90.5),
    (2, 'Smartphone', 50.5),
    (3, 'Headphones', 10.5);
Select * from products;


-- second table............................
CREATE TABLE Secondproducts (
    ProductID INT PRIMARY KEY,
    ProductDescription VARCHAR(255),
    Price DECIMAL(10, 2)
);

INSERT INTO Secondproducts (ProductID, ProductDescription, Price)
VALUES
    (1, 'Laptop', 90.5),
    (2, 'Smartphone', 50.5),
    (3, 'Headphones', 10.5);
Select ProductDescription AS ProductName, Price
    from Secondproducts;


--third table.......................................
CREATE TABLE Thirdproducts (
    ProductID INT PRIMARY KEY,
    ProductDescription VARCHAR(255),
    Price DECIMAL(10, 2),
    Quantity INT
);


INSERT INTO Thirdproducts (ProductID, ProductDescription, Price, Quantity)
VALUES
    (1, 'Laptop', 90.5, NULL),
    (2, 'Smartphone', 50.5, NULL),
    (3, 'Headphones', 10.5, NULL);

-- Update the Quantity for ProductID = 1
UPDATE Thirdproducts
SET Quantity = 10
WHERE ProductID = 1;