CREATE TABLE orders (
order_id INT PRIMARY KEY,
customer_name VARCHAR(50),
order_date DATE,
order_total DECIMAL(10, 2)
);
INSERT INTO orders (order_id, customer_name, order_date, order_total)
VALUES
(1, 'John Doe', '2022-01-01', 100.00),
(2, 'Jane Smith', '2022-01-02', 50.00),
(3, 'John Doe', '2022-01-03', 75.00),
(4, 'Jane Smith', '2022-01-04', 125.00),
(5, 'Bob Johnson', '2022-01-05', 200.00),
(6, 'Alice Lee', '2022-01-06', 150.00),
(7, 'Bob Johnson', '2022-01-07', 75.00),
(8, 'John Doe', '2022-01-08', 100.00),
(9, 'Jane Smith', '2022-01-09', 225.00),
(10, 'Alice Lee', '2022-01-10', 50.00);
