insert-data.sql

-- Customers
INSERT INTO Customers VALUES
(1, 'Alice Johnson', 'alice@example.com', '1234567890', 'New York', '2023-01-01'),
(2, 'Bob Smith', 'bob@example.com', '2345678901', 'Chicago', '2023-02-10'),
(3, 'Carol White', 'carol@example.com', '3456789012', 'Los Angeles', '2023-03-15'),
(4, 'David Brown', 'david@example.com', '4567890123', 'Houston', '2023-04-05'),
(5, 'Eve Davis', 'eve@example.com', '5678901234', 'Phoenix', '2023-05-20');

-- Products
INSERT INTO Products VALUES
(101, 'Laptop', 'Electronics', 750.00, 50),
(102, 'Smartphone', 'Electronics', 500.00, 100),
(103, 'Headphones', 'Accessories', 80.00, 200),
(104, 'Office Chair', 'Furniture', 120.00, 75),
(105, 'Desk Lamp', 'Furniture', 45.00, 150);

-- Orders
INSERT INTO Orders VALUES
(1001, 1, '2024-01-10', 830.00),
(1002, 2, '2024-01-15', 580.00),
(1003, 3, '2024-02-01', 165.00),
(1004, 4, '2024-02-20', 750.00),
(1005, 1, '2024-03-05', 500.00);

-- Order_Details
INSERT INTO Order_Details VALUES
(1, 1001, 101, 1, 750.00),
(2, 1001, 103, 1, 80.00),
(3, 1002, 102, 1, 500.00),
(4, 1002, 105, 2, 40.00),
(5, 1003, 104, 1, 120.00),
(6, 1003, 105, 1, 45.00),
(7, 1004, 101, 1, 750.00),
(8, 1005, 102, 1, 500.00);