CREATE DATABASE test;
use test;
CREATE TABLE orders (
    order_id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    product_id INT NOT NULL,
    quantity INT NOT NULL,
    order_date DATE NOT NULL
);
 INSERT INTO orders (user_id, product_id, quantity, order_date) VALUES
(1001, 101, 2, '2024-01-15'),
(1001, 102, 1, '2024-02-20'),
(1002, 101, 3, '2024-03-10'),
(1002, 103, 1, '2024-04-05'),
(1003, 102, 5, '2024-05-12');
SELECT * FROM orders;