---

CREATE TABLE order_details (
    id INT PRIMARY KEY,
    name VARCHAR(50),
    product_count INT,
    discount INT
);

INSERT INTO order_details (id, name, product_count, discount) VALUES
(1, 'Aaron', 8, 10),
(2, 'Max', 4, 20),
(3, 'Catherine', 6, 30),
(4, 'Catherine', 3, 50),
(5, 'Aaron', 2, 0);