-- 1️⃣ Product টেবিল তৈরি
CREATE TABLE Product (
    ProductID INT PRIMARY KEY,
    ProductName VARCHAR(100) NOT NULL,
    Category VARCHAR(50),
    Price DECIMAL(10,2) NOT NULL,
    Stock INT NOT NULL
);
 
-- 2️⃣ Sell টেবিল তৈরি
CREATE TABLE Sell (
    SellID INT PRIMARY KEY,
    ProductID INT,
    Quantity INT NOT NULL,
    SellDate DATE NOT NULL,
    FOREIGN KEY (ProductID) REFERENCES Product(ProductID)
);
 
-- 3️⃣ Product ডাটা ইনসার্ট
INSERT INTO Product (ProductID, ProductName, Category, Price, Stock)
VALUES
(1, 'T-Shirt', 'Clothing', 450.00, 50),
(2, 'Jeans', 'Clothing', 1200.00, 30),
(3, 'Sneakers', 'Footwear', 2500.00, 20),
(4, 'Cap', 'Accessories', 300.00, 100);
 
-- 4️⃣ Sell ডাটা ইনসার্ট
INSERT INTO Sell (SellID, ProductID, Quantity, SellDate)
VALUES
(101, 1, 20, '2025-08-01'),
(102, 1, 15, '2025-08-03'),
(103, 2, 5, '2025-08-04'),
(104, 3, 10, '2025-08-05'),
(105, 4, 12, '2025-08-06'),
(106, 4, 25, '2025-08-07');
 
-- 5️⃣ যেসব প্রোডাক্টের মোট সেল 30 এর বেশি
SELECT 
    p.ProductID,
    p.ProductName,
    SUM(s.Quantity) AS TotalSold
FROM Product p
JOIN Sell s ON p.ProductID = s.ProductID
GROUP BY p.ProductID, p.ProductName
HAVING SUM(s.Quantity) > 30;

LS0gMe+4j+KDoyBQcm9kdWN0IOCmn+Cnh+CmrOCmv+CmsiDgpqTgp4jgprDgpr8KQ1JFQVRFIFRBQkxFIFByb2R1Y3QgKAogICAgUHJvZHVjdElEIElOVCBQUklNQVJZIEtFWSwKICAgIFByb2R1Y3ROYW1lIFZBUkNIQVIoMTAwKSBOT1QgTlVMTCwKICAgIENhdGVnb3J5IFZBUkNIQVIoNTApLAogICAgUHJpY2UgREVDSU1BTCgxMCwyKSBOT1QgTlVMTCwKICAgIFN0b2NrIElOVCBOT1QgTlVMTAopOwoKLS0gMu+4j+KDoyBTZWxsIOCmn+Cnh+CmrOCmv+CmsiDgpqTgp4jgprDgpr8KQ1JFQVRFIFRBQkxFIFNlbGwgKAogICAgU2VsbElEIElOVCBQUklNQVJZIEtFWSwKICAgIFByb2R1Y3RJRCBJTlQsCiAgICBRdWFudGl0eSBJTlQgTk9UIE5VTEwsCiAgICBTZWxsRGF0ZSBEQVRFIE5PVCBOVUxMLAogICAgRk9SRUlHTiBLRVkgKFByb2R1Y3RJRCkgUkVGRVJFTkNFUyBQcm9kdWN0KFByb2R1Y3RJRCkKKTsKCi0tIDPvuI/ig6MgUHJvZHVjdCDgpqHgpr7gpp/gpr4g4KaH4Kao4Ka44Ka+4Kaw4KeN4KafCklOU0VSVCBJTlRPIFByb2R1Y3QgKFByb2R1Y3RJRCwgUHJvZHVjdE5hbWUsIENhdGVnb3J5LCBQcmljZSwgU3RvY2spClZBTFVFUwooMSwgJ1QtU2hpcnQnLCAnQ2xvdGhpbmcnLCA0NTAuMDAsIDUwKSwKKDIsICdKZWFucycsICdDbG90aGluZycsIDEyMDAuMDAsIDMwKSwKKDMsICdTbmVha2VycycsICdGb290d2VhcicsIDI1MDAuMDAsIDIwKSwKKDQsICdDYXAnLCAnQWNjZXNzb3JpZXMnLCAzMDAuMDAsIDEwMCk7CgotLSA077iP4oOjIFNlbGwg4Kah4Ka+4Kaf4Ka+IOCmh+CmqOCmuOCmvuCmsOCnjeCmnwpJTlNFUlQgSU5UTyBTZWxsIChTZWxsSUQsIFByb2R1Y3RJRCwgUXVhbnRpdHksIFNlbGxEYXRlKQpWQUxVRVMKKDEwMSwgMSwgMjAsICcyMDI1LTA4LTAxJyksCigxMDIsIDEsIDE1LCAnMjAyNS0wOC0wMycpLAooMTAzLCAyLCA1LCAnMjAyNS0wOC0wNCcpLAooMTA0LCAzLCAxMCwgJzIwMjUtMDgtMDUnKSwKKDEwNSwgNCwgMTIsICcyMDI1LTA4LTA2JyksCigxMDYsIDQsIDI1LCAnMjAyNS0wOC0wNycpOwoKLS0gNe+4j+KDoyDgpq/gp4fgprjgpqwg4Kaq4KeN4Kaw4KeL4Kah4Ka+4KaV4KeN4Kaf4KeH4KawIOCmruCni+CmnyDgprjgp4fgprIgMzAg4KaP4KawIOCmrOCnh+CmtuCmvwpTRUxFQ1QgCiAgICBwLlByb2R1Y3RJRCwKICAgIHAuUHJvZHVjdE5hbWUsCiAgICBTVU0ocy5RdWFudGl0eSkgQVMgVG90YWxTb2xkCkZST00gUHJvZHVjdCBwCkpPSU4gU2VsbCBzIE9OIHAuUHJvZHVjdElEID0gcy5Qcm9kdWN0SUQKR1JPVVAgQlkgcC5Qcm9kdWN0SUQsIHAuUHJvZHVjdE5hbWUKSEFWSU5HIFNVTShzLlF1YW50aXR5KSA+IDMwOw==