-- Step 1: Create Table
CREATE TABLE Bike_shop (
    bike_id INT PRIMARY KEY,
    model_name VARCHAR(100),
    brand VARCHAR(50),
    price DECIMAL(10, 2),
    serial_number VARCHAR(50),
    stock_quantity INT,
    date_received DATE
);

-- Step 2: Insert 10 Sample Rows
INSERT INTO Bike_shop (bike_id, model_name, brand, price, serial_number, stock_quantity, date_received) VALUES
(1, 'Trail Blazer 26', 'Giant', 18500.00, 'GT-0001', 12, '2026-01-15'),
(2, 'City Cruiser Pro', 'Trek', 22500.00, 'TK-0002', 8, '2026-02-10'),
(3, 'Mountain King X1', 'Merida', 34500.00, 'MD-0003', 5, '2026-03-01'),
(4, 'Road Runner Elite', 'Specialized', 65000.00, 'SP-0004', 3, '2026-03-20'),
(5, 'Kids Explorer 20', 'Giant', 9500.00, 'GT-0005', 20, '2026-04-05'),
(6, 'Urban Commuter', 'Trek', 15500.00, 'TK-0006', 15, '2026-05-12'),
(7, 'BMX Street Pro', 'Mongoose', 12500.00, 'MG-0007', 10, '2026-06-18'),
(8, 'Hybrid Comfort Ride', 'Merida', 19500.00, 'MD-0008', 7, '2026-07-22'),
(9, 'Fat Tire Adventure', 'Specialized', 41500.00, 'SP-0009', 4, '2026-08-30'),
(10, 'Electric Glide E1', 'Giant', 78500.00, 'GT-0010', 6, '2026-09-14');