drop table if exists customers ; drop table if exists products ; drop table if exists orders ; CREATE TABLE customers ( customer_id INT, customer_name VARCHAR(50), customer_email VARCHAR(50), customer_age INT, PRIMARY KEY (customer_id) ); INSERT INTO customers (customer_id, customer_name, customer_email, customer_age) VALUES (1, 'Alice', 'alice@example.com', 25), (2, 'Bob', 'bob@example.com', 30), (3, 'Charlie', 'charlie@example.com', 22), (4, 'David', 'david@example.com', 18), (5, 'Eve', 'eve@example.com', 35); CREATE TABLE products ( product_id INT, product_name VARCHAR(50), unit_price DECIMAL(10, 2), PRIMARY KEY (product_id) ); INSERT INTO products (product_id, product_name, unit_price) VALUES (101, 'Product A', 50.00), (102, 'Product B', 75.00), (103, 'Product C', 100.00), (104, 'Product D', 120.00), (105, 'Product E', 90.00); CREATE TABLE orders ( order_id INT, customer_id INT, product_id INT, quantity INT, order_date DATE, PRIMARY KEY (order_id) ); INSERT INTO orders (order_id, customer_id, product_id, quantity, order_date) VALUES (1, 1, 101, 2, '2023-01-15'), (2, 2, 102, 3, '2023-02-20'), (3, 3, 103, 1, '2023-03-10'), (4, 4, 104, 2, '2023-04-05'), (5, 5, 105, 4, '2023-05-12'), (6, 1, 102, 2, '2023-06-18'), (7, 2, 103, 3, '2023-07-22'), (8, 3, 104, 1, '2023-08-30'), (9, 4, 105, 2, '2023-09-14'), (10, 5, 101, 4, '2023-10-25'), (11, 1, 103, 2, '2023-11-08'), (12, 2, 104, 3, '2023-12-19'), (13, 3, 104, 1, '2023-12-20'); 给一组测试数据楼主，仅对样例的orders表格插入了一行数据(13, 3, 104, 1, '2023-12-20')