-- 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
);
 
-- Sell টেবিল তৈরি
CREATE TABLE Sell (
    SellID INT PRIMARY KEY,
    ProductID INT,
    Quantity INT NOT NULL,
    SellDate DATE NOT NULL,
    FOREIGN KEY (ProductID) REFERENCES Product(ProductID)
);
 
-- Product ডাটা ইনসার্ট
INSERT INTO Product (ProductID, ProductName, Category, Price, Stock)
VALUES
(1, 'Smart T-Shirt', 'Clothing', 450.00, 50),
(2, 'Smart Jeans', 'Clothing', 1200.00, 30),
(3, 'Sneakers', 'Footwear', 2500.00, 20),
(4, 'Cap', 'Accessories', 300.00, 100);
 
-- 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');
 
-- প্রশ্ন ২: 'Smart' নাম আছে এমন প্রোডাক্টের সেল ডিটেইলস
SELECT 
    s.SellID,
    p.ProductName,
    s.Quantity,
    s.SellDate,
    (s.Quantity * p.Price) AS TotalPrice
FROM Sell s
JOIN Product p ON s.ProductID = p.ProductID
WHERE p.ProductName LIKE '%Smart%';

LS0gUHJvZHVjdCDgpp/gp4fgpqzgpr/gprIg4Kak4KeI4Kaw4Ka/CkNSRUFURSBUQUJMRSBQcm9kdWN0ICgKICAgIFByb2R1Y3RJRCBJTlQgUFJJTUFSWSBLRVksCiAgICBQcm9kdWN0TmFtZSBWQVJDSEFSKDEwMCkgTk9UIE5VTEwsCiAgICBDYXRlZ29yeSBWQVJDSEFSKDUwKSwKICAgIFByaWNlIERFQ0lNQUwoMTAsMikgTk9UIE5VTEwsCiAgICBTdG9jayBJTlQgTk9UIE5VTEwKKTsKCi0tIFNlbGwg4Kaf4KeH4Kas4Ka/4KayIOCmpOCniOCmsOCmvwpDUkVBVEUgVEFCTEUgU2VsbCAoCiAgICBTZWxsSUQgSU5UIFBSSU1BUlkgS0VZLAogICAgUHJvZHVjdElEIElOVCwKICAgIFF1YW50aXR5IElOVCBOT1QgTlVMTCwKICAgIFNlbGxEYXRlIERBVEUgTk9UIE5VTEwsCiAgICBGT1JFSUdOIEtFWSAoUHJvZHVjdElEKSBSRUZFUkVOQ0VTIFByb2R1Y3QoUHJvZHVjdElEKQopOwoKLS0gUHJvZHVjdCDgpqHgpr7gpp/gpr4g4KaH4Kao4Ka44Ka+4Kaw4KeN4KafCklOU0VSVCBJTlRPIFByb2R1Y3QgKFByb2R1Y3RJRCwgUHJvZHVjdE5hbWUsIENhdGVnb3J5LCBQcmljZSwgU3RvY2spClZBTFVFUwooMSwgJ1NtYXJ0IFQtU2hpcnQnLCAnQ2xvdGhpbmcnLCA0NTAuMDAsIDUwKSwKKDIsICdTbWFydCBKZWFucycsICdDbG90aGluZycsIDEyMDAuMDAsIDMwKSwKKDMsICdTbmVha2VycycsICdGb290d2VhcicsIDI1MDAuMDAsIDIwKSwKKDQsICdDYXAnLCAnQWNjZXNzb3JpZXMnLCAzMDAuMDAsIDEwMCk7CgotLSBTZWxsIOCmoeCmvuCmn+CmviDgpofgpqjgprjgpr7gprDgp43gpp8KSU5TRVJUIElOVE8gU2VsbCAoU2VsbElELCBQcm9kdWN0SUQsIFF1YW50aXR5LCBTZWxsRGF0ZSkKVkFMVUVTCigxMDEsIDEsIDIwLCAnMjAyNS0wOC0wMScpLAooMTAyLCAxLCAxNSwgJzIwMjUtMDgtMDMnKSwKKDEwMywgMiwgNSwgJzIwMjUtMDgtMDQnKSwKKDEwNCwgMywgMTAsICcyMDI1LTA4LTA1JyksCigxMDUsIDQsIDEyLCAnMjAyNS0wOC0wNicpLAooMTA2LCA0LCAyNSwgJzIwMjUtMDgtMDcnKTsKCi0tIOCmquCnjeCmsOCmtuCnjeCmqCDgp6g6ICdTbWFydCcg4Kao4Ka+4KauIOCmhuCmm+CnhyDgpo/gpq7gpqgg4Kaq4KeN4Kaw4KeL4Kah4Ka+4KaV4KeN4Kaf4KeH4KawIOCmuOCnh+CmsiDgpqHgpr/gpp/gp4fgpofgprLgprgKU0VMRUNUIAogICAgcy5TZWxsSUQsCiAgICBwLlByb2R1Y3ROYW1lLAogICAgcy5RdWFudGl0eSwKICAgIHMuU2VsbERhdGUsCiAgICAocy5RdWFudGl0eSAqIHAuUHJpY2UpIEFTIFRvdGFsUHJpY2UKRlJPTSBTZWxsIHMKSk9JTiBQcm9kdWN0IHAgT04gcy5Qcm9kdWN0SUQgPSBwLlByb2R1Y3RJRApXSEVSRSBwLlByb2R1Y3ROYW1lIExJS0UgJyVTbWFydCUnOw==