CREATE TABLE CUSTOMERS (
    Customer_id INTEGER PRIMARY KEY,
    Customer_name TEXT NOT NULL
);

CREATE TABLE ORDERS (
    Order_id INTEGER,
    Customer_id INTEGER,
    
    FOREIGN KEY (Customer_id) REFERENCES CUSTOMERS(Customer_id)
);

-- Insert 30 Customers
INSERT INTO CUSTOMERS (Customer_id, Customer_name) VALUES
(1, 'Alice Johnson'),
(2, 'Bob Smith'),
(3, 'Charlie Davis'),
(4, 'David White'),
(5, 'Emma Brown'),
(6, 'Frank Green'),
(7, 'Grace Adams'),
(8, 'Hannah Carter'),
(9, 'Ian Roberts'),
(10, 'Jack Lewis'),
(11, 'Kelly Scott'),
(12, 'Liam Walker'),
(13, 'Mia Hall'),
(14, 'Nathan Baker'),
(15, 'Olivia Turner'),
(16, 'Paul Harris'),
(17, 'Quinn Young'),
(18, 'Rachel King'),
(19, 'Samuel Wright'),
(20, 'Tina Lopez'),
(21, 'Uma Nelson'),
(22, 'Victor Allen'),
(23, 'Wendy Perez'),
(24, 'Xavier Bennett'),
(25, 'Yvonne Rivera'),
(26, 'Zachary Simmons'),
(27, 'Angela Martin'),
(28, 'Bruce Foster'),
(29, 'Catherine Reed'),
(30, 'Derek Brooks');

-- Insert 60 Orders (Some duplicate and some without orders)
INSERT INTO ORDERS (Order_id, Customer_id) VALUES
(101, 1), (102, 2), (103, 3), (104, 4), (105, 5),
(106, 6), (107, 7), (108, 8), (109, 9), (110, 10),
(111, 11), (112, 12), (113, 13), (114, 14), (115, 15),
(116, 16), (117, 17), (118, 18), (119, 19), (120, 20),
(121, 21), (122, 22), (123, 23), (124, 24), (125, 25),
(126, 26), (127, 27), (128, 28), (129, 29), (130, 30),
-- Duplicate Orders
(101, 1), (102, 2), (103, 3), (104, 4), (105, 5),
(106, 6), (107, 7), (108, 8), (109, 9), (110, 10),
-- More Orders
(131, 1), (132, 2), (133, 3), (134, 4), (135, 5),
(136, 6), (137, 7), (138, 8), (139, 9), (140, 10),
(141, 11), (142, 12), (143, 13), (144, 14), (145, 15),
(146, 16), (147, 17), (148, 18), (149, 19), (150, 20);