USE cinema_chain;

INSERT INTO auditorium_type (Name, Description, Price_Multiplier) VALUES
('Regular', 'Standard 2D screening room', 1.00),
('IMAX', 'Large format immersive experience', 1.50),
('VIP', 'Premium seats with waiter service', 1.75),
('4DX', 'Motion seats with environmental effects', 1.60),
('3D', 'Stereoscopic 3D projection', 1.25);

INSERT INTO genre (Name) VALUES
('Action'), ('Comedy'), ('Drama'), ('Horror'), ('Sci-Fi'),
('Animation'), ('Thriller'), ('Romance');

INSERT INTO showtime_group (Name, Start_Range, End_Range) VALUES
('Morning', '06:00:00', '11:59:59'),
('Afternoon', '12:00:00', '17:59:59'),
('Evening', '18:00:00', '21:59:59'),
('Late Night', '22:00:00', '05:59:59');

INSERT INTO ticket_status (Name) VALUES
('Booked'), ('Used'), ('Cancelled');

INSERT INTO product_category (Name) VALUES
('Popcorn'), ('Beverage'), ('Candy'), ('Combo'), ('Snack');

INSERT INTO payment_method (Name) VALUES
('Credit Card'), ('Debit Card'), ('Cash');

INSERT INTO customer (First_Name, Last_Name, Email, Phone, Registration_Date) VALUES
('Maria', 'Garcia', 'maria.garcia@email.com', '+34612345678', '2024-01-15 10:30:00'),
('Carlos', 'Rodriguez', 'carlos.r@email.com', '+34623456789', '2024-02-20 14:45:00'),
('Ana', 'Martinez', 'ana.martinez@email.com', '+34634567890', '2024-03-10 09:15:00'),
('Pedro', 'Lopez', 'pedro.lopez@email.com', '+34645678901', '2024-04-05 16:00:00'),
('Laura', 'Sanchez', 'laura.s@email.com', '+34656789012', '2024-05-12 11:30:00'),
('Diego', 'Fernandez', 'diego.f@email.com', '+34667890123', '2024-06-18 13:45:00'),
('Sofia', 'Gonzalez', 'sofia.g@email.com', '+34678901234', '2024-07-22 15:00:00'),
('Pablo', 'Ruiz', 'pablo.ruiz@email.com', '+34689012345', '2024-08-30 10:00:00'),
('Elena', 'Diaz', 'elena.diaz@email.com', '+34690123456', '2024-09-14 12:00:00'),
('Javier', 'Moreno', 'javier.m@email.com', '+34601234567', '2024-10-01 14:00:00'),
('Carmen', 'Jimenez', 'carmen.j@email.com', '+34612345679', '2024-10-15 16:30:00'),
('Alberto', 'Romero', 'alberto.r@email.com', '+34623456780', '2024-11-01 09:00:00'),
('Lucia', 'Navarro', 'lucia.n@email.com', '+34634567891', '2024-11-20 11:00:00'),
('Miguel', 'Torres', 'miguel.t@email.com', '+34645678902', '2024-12-01 13:00:00'),
('Isabel', 'Dominguez', 'isabel.d@email.com', '+34656789013', '2025-01-10 15:00:00');

INSERT INTO location (Name, Address, City, Zip_Code, Country, Phone) VALUES
('CinemaChain Gran Via', 'Gran Via 32', 'Madrid', '28013', 'Spain', '+34915551234'),
('CinemaChain Diagonal', 'Av. Diagonal 605', 'Barcelona', '08028', 'Spain', '+34935552345'),
('CinemaChain Centro', 'Calle Sierpes 15', 'Sevilla', '41004', 'Spain', '+34955553456');

INSERT INTO auditorium (Location_ID, Auditorium_Type_ID, Name, Total_Seats) VALUES
(1, 1, 'Sala 1', 150),
(1, 2, 'Sala IMAX', 200),
(1, 3, 'Sala VIP', 50),
(2, 1, 'Sala 1', 120),
(2, 4, 'Sala 4DX', 80),
(2, 5, 'Sala 3D', 100),
(3, 1, 'Sala 1', 100),
(3, 1, 'Sala 2', 100);

INSERT INTO seat (Auditorium_ID, Row_Code, Seat_Number, Is_Accessible) VALUES
(1, 'A', 1, TRUE), (1, 'A', 2, FALSE), (1, 'A', 3, FALSE), (1, 'A', 4, FALSE), (1, 'A', 5, FALSE),
(1, 'B', 1, FALSE), (1, 'B', 2, FALSE), (1, 'B', 3, FALSE), (1, 'B', 4, FALSE), (1, 'B', 5, FALSE),
(1, 'C', 1, FALSE), (1, 'C', 2, FALSE), (1, 'C', 3, FALSE), (1, 'C', 4, FALSE), (1, 'C', 5, FALSE),
(1, 'D', 1, FALSE), (1, 'D', 2, FALSE), (1, 'D', 3, FALSE), (1, 'D', 4, FALSE), (1, 'D', 5, FALSE),
(2, 'A', 1, TRUE), (2, 'A', 2, FALSE), (2, 'A', 3, FALSE), (2, 'A', 4, FALSE), (2, 'A', 5, FALSE),
(2, 'B', 1, FALSE), (2, 'B', 2, FALSE), (2, 'B', 3, FALSE), (2, 'B', 4, FALSE), (2, 'B', 5, FALSE),
(2, 'C', 1, FALSE), (2, 'C', 2, FALSE), (2, 'C', 3, FALSE), (2, 'C', 4, FALSE), (2, 'C', 5, FALSE),
(2, 'D', 1, FALSE), (2, 'D', 2, FALSE), (2, 'D', 3, FALSE), (2, 'D', 4, FALSE), (2, 'D', 5, FALSE),
(3, 'A', 1, TRUE), (3, 'A', 2, FALSE), (3, 'A', 3, FALSE), (3, 'A', 4, FALSE), (3, 'A', 5, FALSE),
(3, 'B', 1, FALSE), (3, 'B', 2, FALSE), (3, 'B', 3, FALSE), (3, 'B', 4, FALSE), (3, 'B', 5, FALSE),
(3, 'C', 1, FALSE), (3, 'C', 2, FALSE), (3, 'C', 3, FALSE), (3, 'C', 4, FALSE), (3, 'C', 5, FALSE),
(3, 'D', 1, FALSE), (3, 'D', 2, FALSE), (3, 'D', 3, FALSE), (3, 'D', 4, FALSE), (3, 'D', 5, FALSE),
(4, 'A', 1, TRUE), (4, 'A', 2, FALSE), (4, 'A', 3, FALSE), (4, 'A', 4, FALSE), (4, 'A', 5, FALSE),
(4, 'B', 1, FALSE), (4, 'B', 2, FALSE), (4, 'B', 3, FALSE), (4, 'B', 4, FALSE), (4, 'B', 5, FALSE),
(4, 'C', 1, FALSE), (4, 'C', 2, FALSE), (4, 'C', 3, FALSE), (4, 'C', 4, FALSE), (4, 'C', 5, FALSE),
(4, 'D', 1, FALSE), (4, 'D', 2, FALSE), (4, 'D', 3, FALSE), (4, 'D', 4, FALSE), (4, 'D', 5, FALSE),
(5, 'A', 1, TRUE), (5, 'A', 2, FALSE), (5, 'A', 3, FALSE), (5, 'A', 4, FALSE), (5, 'A', 5, FALSE),
(5, 'B', 1, FALSE), (5, 'B', 2, FALSE), (5, 'B', 3, FALSE), (5, 'B', 4, FALSE), (5, 'B', 5, FALSE),
(5, 'C', 1, FALSE), (5, 'C', 2, FALSE), (5, 'C', 3, FALSE), (5, 'C', 4, FALSE), (5, 'C', 5, FALSE),
(5, 'D', 1, FALSE), (5, 'D', 2, FALSE), (5, 'D', 3, FALSE), (5, 'D', 4, FALSE), (5, 'D', 5, FALSE),
(6, 'A', 1, TRUE), (6, 'A', 2, FALSE), (6, 'A', 3, FALSE), (6, 'A', 4, FALSE), (6, 'A', 5, FALSE),
(6, 'B', 1, FALSE), (6, 'B', 2, FALSE), (6, 'B', 3, FALSE), (6, 'B', 4, FALSE), (6, 'B', 5, FALSE),
(6, 'C', 1, FALSE), (6, 'C', 2, FALSE), (6, 'C', 3, FALSE), (6, 'C', 4, FALSE), (6, 'C', 5, FALSE),
(6, 'D', 1, FALSE), (6, 'D', 2, FALSE), (6, 'D', 3, FALSE), (6, 'D', 4, FALSE), (6, 'D', 5, FALSE),
(7, 'A', 1, TRUE), (7, 'A', 2, FALSE), (7, 'A', 3, FALSE), (7, 'A', 4, FALSE), (7, 'A', 5, FALSE),
(7, 'B', 1, FALSE), (7, 'B', 2, FALSE), (7, 'B', 3, FALSE), (7, 'B', 4, FALSE), (7, 'B', 5, FALSE),
(7, 'C', 1, FALSE), (7, 'C', 2, FALSE), (7, 'C', 3, FALSE), (7, 'C', 4, FALSE), (7, 'C', 5, FALSE),
(7, 'D', 1, FALSE), (7, 'D', 2, FALSE), (7, 'D', 3, FALSE), (7, 'D', 4, FALSE), (7, 'D', 5, FALSE),
(8, 'A', 1, TRUE), (8, 'A', 2, FALSE), (8, 'A', 3, FALSE), (8, 'A', 4, FALSE), (8, 'A', 5, FALSE),
(8, 'B', 1, FALSE), (8, 'B', 2, FALSE), (8, 'B', 3, FALSE), (8, 'B', 4, FALSE), (8, 'B', 5, FALSE),
(8, 'C', 1, FALSE), (8, 'C', 2, FALSE), (8, 'C', 3, FALSE), (8, 'C', 4, FALSE), (8, 'C', 5, FALSE),
(8, 'D', 1, FALSE), (8, 'D', 2, FALSE), (8, 'D', 3, FALSE), (8, 'D', 4, FALSE), (8, 'D', 5, FALSE);

INSERT INTO film (Title, Duration_Minutes, Rating, Release_Date, Licensing_Cost) VALUES
('Dune: Part Two', 166, 'PG-13', '2024-03-01', 1500.00),
('Inside Out 2', 96, 'PG', '2024-06-14', 1000.00),
('Deadpool & Wolverine', 128, 'R', '2024-07-26', 1200.00),
('Gladiator II', 148, 'R', '2024-11-15', 1100.00),
('Wicked', 160, 'PG', '2024-11-22', 900.00);

INSERT INTO film_genre (Film_ID, Genre_ID) VALUES
(1, 1), (1, 5),
(2, 6), (2, 2),
(3, 1), (3, 2),
(4, 1), (4, 3),
(5, 3), (5, 8);

INSERT INTO product (Category_ID, Name, Sub_Type, Size, Unit_Cost, Sales_Price) VALUES
(1, 'Classic Popcorn', 'Salted', 'Small', 1.00, 4.50),
(1, 'Classic Popcorn', 'Salted', 'Medium', 1.50, 6.00),
(1, 'Classic Popcorn', 'Salted', 'Large', 2.00, 8.00),
(2, 'Coca-Cola', 'Soda', 'Small', 0.50, 3.00),
(2, 'Coca-Cola', 'Soda', 'Medium', 0.75, 4.00),
(2, 'Coca-Cola', 'Soda', 'Large', 1.00, 5.50),
(2, 'Water', 'Still', 'Small', 0.25, 2.50),
(3, 'M&Ms', 'Chocolate', 'Regular', 1.50, 4.00),
(3, 'Gummy Bears', 'Gummy', 'Regular', 1.00, 3.50),
(5, 'Nachos', 'With Cheese', 'Regular', 2.00, 6.50);

INSERT INTO showtime (Film_ID, Auditorium_ID, Showtime_Group_ID, Start_DateTime, Ticket_Price) VALUES
(1, 2, 3, '2025-01-15 19:00:00', 18.00),
(1, 2, 3, '2025-02-12 20:00:00', 18.00),
(1, 2, 3, '2025-03-15 19:30:00', 21.00),
(1, 3, 3, '2025-03-20 20:00:00', 24.00),
(2, 1, 2, '2025-04-18 15:00:00', 10.00),
(2, 4, 2, '2025-05-10 14:00:00', 10.00),
(2, 1, 2, '2025-06-20 15:00:00', 10.00),
(3, 2, 3, '2025-07-26 19:00:00', 19.00),
(3, 5, 3, '2025-08-10 20:00:00', 17.00),
(3, 2, 3, '2025-09-14 19:00:00', 18.00),
(4, 2, 3, '2025-10-25 19:00:00', 18.00),
(4, 3, 3, '2025-11-20 20:00:00', 26.00),
(5, 1, 3, '2025-11-28 19:00:00', 11.00),
(5, 4, 3, '2025-12-15 19:00:00', 11.00),
(1, 5, 3, '2025-01-18 19:00:00', 16.00),
(1, 7, 3, '2025-01-20 19:00:00', 10.00),
(1, 6, 3, '2025-02-15 19:00:00', 13.00),
(1, 8, 3, '2025-02-18 19:00:00', 10.00),
(1, 5, 3, '2025-03-18 19:00:00', 16.00),
(1, 7, 3, '2025-03-22 19:00:00', 10.00),
(2, 6, 2, '2025-04-20 14:00:00', 11.00),
(2, 8, 2, '2025-04-22 14:00:00', 9.00),
(2, 7, 2, '2025-05-15 14:00:00', 10.00),
(2, 4, 2, '2025-06-25 14:00:00', 10.00),
(2, 8, 2, '2025-06-27 14:00:00', 9.00),
(3, 6, 3, '2025-07-28 19:00:00', 14.00),
(3, 7, 3, '2025-07-30 19:00:00', 11.00),
(3, 8, 3, '2025-08-15 19:00:00', 11.00),
(3, 5, 3, '2025-09-18 19:00:00', 16.00),
(3, 7, 3, '2025-09-20 19:00:00', 11.00),
(4, 6, 3, '2025-10-28 19:00:00', 13.00),
(4, 8, 3, '2025-10-30 19:00:00', 11.00),
(4, 5, 3, '2025-11-25 19:00:00', 17.00),
(5, 7, 3, '2025-11-27 19:00:00', 10.00),
(5, 8, 3, '2025-12-20 19:00:00', 10.00);

INSERT INTO movie_ticket (Customer_ID, Showtime_ID, Seat_ID, Location_ID, Purchase_DateTime, Payment_Method_ID, Price, Tax_Amount, Total_Amount, Status_ID) VALUES
(1, 1, 21, 1, '2025-01-14 18:00:00', 1, 18.00, 3.78, 21.78, 2),
(2, 1, 22, 1, '2025-01-14 18:15:00', 2, 18.00, 3.78, 21.78, 2),
(3, 1, 23, 1, '2025-01-14 18:30:00', 1, 18.00, 3.78, 21.78, 2),
(4, 1, 24, 1, '2025-01-14 18:45:00', 1, 18.00, 3.78, 21.78, 2),
(5, 1, 25, 1, '2025-01-14 19:00:00', 2, 18.00, 3.78, 21.78, 2),
(6, 1, 26, 1, '2025-01-15 10:00:00', 1, 18.00, 3.78, 21.78, 2),
(7, 1, 27, 1, '2025-01-15 10:30:00', 1, 18.00, 3.78, 21.78, 2),
(8, 1, 28, 1, '2025-01-15 11:00:00', 2, 18.00, 3.78, 21.78, 2),
(9, 1, 29, 1, '2025-01-15 11:30:00', 1, 18.00, 3.78, 21.78, 2),
(10, 1, 30, 1, '2025-01-15 12:00:00', 1, 18.00, 3.78, 21.78, 2),
(11, 1, 31, 1, '2025-01-15 12:30:00', 2, 18.00, 3.78, 21.78, 2),
(12, 1, 32, 1, '2025-01-15 13:00:00', 1, 18.00, 3.78, 21.78, 2),
(13, 2, 21, 1, '2025-02-11 18:00:00', 1, 18.00, 3.78, 21.78, 2),
(14, 2, 22, 1, '2025-02-11 18:30:00', 2, 18.00, 3.78, 21.78, 2),
(15, 2, 23, 1, '2025-02-11 19:00:00', 1, 18.00, 3.78, 21.78, 2),
(1, 2, 24, 1, '2025-02-11 19:30:00', 1, 18.00, 3.78, 21.78, 2),
(2, 2, 25, 1, '2025-02-12 10:00:00', 2, 18.00, 3.78, 21.78, 2),
(3, 2, 26, 1, '2025-02-12 10:30:00', 1, 18.00, 3.78, 21.78, 2),
(4, 2, 27, 1, '2025-02-12 11:00:00', 1, 18.00, 3.78, 21.78, 2),
(5, 2, 28, 1, '2025-02-12 11:30:00', 2, 18.00, 3.78, 21.78, 2),
(6, 2, 29, 1, '2025-02-12 12:00:00', 1, 18.00, 3.78, 21.78, 2),
(7, 2, 30, 1, '2025-02-12 12:30:00', 1, 18.00, 3.78, 21.78, 2),
(8, 3, 21, 1, '2025-03-14 18:00:00', 1, 21.00, 4.41, 25.41, 2),
(9, 3, 22, 1, '2025-03-14 18:15:00', 2, 21.00, 4.41, 25.41, 2),
(10, 3, 23, 1, '2025-03-14 18:30:00', 1, 21.00, 4.41, 25.41, 2),
(11, 3, 24, 1, '2025-03-14 18:45:00', 1, 21.00, 4.41, 25.41, 2),
(12, 3, 25, 1, '2025-03-14 19:00:00', 2, 21.00, 4.41, 25.41, 2),
(13, 3, 26, 1, '2025-03-14 19:15:00', 1, 21.00, 4.41, 25.41, 2),
(14, 3, 27, 1, '2025-03-14 19:30:00', 1, 21.00, 4.41, 25.41, 2),
(15, 3, 28, 1, '2025-03-14 19:45:00', 2, 21.00, 4.41, 25.41, 2),
(1, 3, 29, 1, '2025-03-15 10:00:00', 1, 21.00, 4.41, 25.41, 2),
(2, 3, 30, 1, '2025-03-15 10:30:00', 1, 21.00, 4.41, 25.41, 2),
(3, 3, 31, 1, '2025-03-15 11:00:00', 2, 21.00, 4.41, 25.41, 2),
(4, 3, 32, 1, '2025-03-15 11:30:00', 1, 21.00, 4.41, 25.41, 2),
(5, 3, 33, 1, '2025-03-15 12:00:00', 1, 21.00, 4.41, 25.41, 2),
(6, 3, 34, 1, '2025-03-15 12:30:00', 2, 21.00, 4.41, 25.41, 2),
(7, 3, 35, 1, '2025-03-15 13:00:00', 1, 21.00, 4.41, 25.41, 2),
(8, 4, 41, 1, '2025-03-19 19:00:00', 1, 24.00, 5.04, 29.04, 2),
(9, 4, 42, 1, '2025-03-19 19:30:00', 2, 24.00, 5.04, 29.04, 2),
(10, 4, 43, 1, '2025-03-19 20:00:00', 1, 24.00, 5.04, 29.04, 2),
(11, 4, 44, 1, '2025-03-20 10:00:00', 1, 24.00, 5.04, 29.04, 2),
(12, 4, 45, 1, '2025-03-20 10:30:00', 2, 24.00, 5.04, 29.04, 2),
(13, 5, 1, 1, '2025-04-17 14:00:00', 1, 10.00, 2.10, 12.10, 2),
(14, 5, 2, 1, '2025-04-17 14:30:00', 2, 10.00, 2.10, 12.10, 2),
(15, 5, 3, 1, '2025-04-17 15:00:00', 1, 10.00, 2.10, 12.10, 2),
(1, 5, 4, 1, '2025-04-18 10:00:00', 1, 10.00, 2.10, 12.10, 2),
(2, 5, 5, 1, '2025-04-18 10:30:00', 2, 10.00, 2.10, 12.10, 2),
(3, 5, 6, 1, '2025-04-18 11:00:00', 1, 10.00, 2.10, 12.10, 2),
(4, 5, 7, 1, '2025-04-18 11:30:00', 1, 10.00, 2.10, 12.10, 2),
(5, 5, 8, 1, '2025-04-18 12:00:00', 2, 10.00, 2.10, 12.10, 2),
(6, 5, 9, 1, '2025-04-18 12:30:00', 1, 10.00, 2.10, 12.10, 2),
(7, 5, 10, 1, '2025-04-18 13:00:00', 1, 10.00, 2.10, 12.10, 2),
(8, 6, 61, 2, '2025-05-09 13:00:00', 1, 10.00, 2.10, 12.10, 2),
(9, 6, 62, 2, '2025-05-09 13:30:00', 2, 10.00, 2.10, 12.10, 2),
(10, 6, 63, 2, '2025-05-09 14:00:00', 1, 10.00, 2.10, 12.10, 2),
(11, 6, 64, 2, '2025-05-10 10:00:00', 1, 10.00, 2.10, 12.10, 2),
(12, 6, 65, 2, '2025-05-10 10:30:00', 2, 10.00, 2.10, 12.10, 2),
(13, 6, 66, 2, '2025-05-10 11:00:00', 1, 10.00, 2.10, 12.10, 2),
(14, 6, 67, 2, '2025-05-10 11:30:00', 1, 10.00, 2.10, 12.10, 2),
(15, 6, 68, 2, '2025-05-10 12:00:00', 2, 10.00, 2.10, 12.10, 2),
(1, 7, 1, 1, '2025-06-19 14:00:00', 1, 10.00, 2.10, 12.10, 2),
(2, 7, 2, 1, '2025-06-19 14:30:00', 2, 10.00, 2.10, 12.10, 2),
(3, 7, 3, 1, '2025-06-19 15:00:00', 1, 10.00, 2.10, 12.10, 2),
(4, 7, 4, 1, '2025-06-20 10:00:00', 1, 10.00, 2.10, 12.10, 2),
(5, 7, 5, 1, '2025-06-20 10:30:00', 2, 10.00, 2.10, 12.10, 2),
(6, 7, 6, 1, '2025-06-20 11:00:00', 1, 10.00, 2.10, 12.10, 2),
(7, 7, 7, 1, '2025-06-20 11:30:00', 1, 10.00, 2.10, 12.10, 2),
(8, 7, 8, 1, '2025-06-20 12:00:00', 2, 10.00, 2.10, 12.10, 2),
(9, 7, 9, 1, '2025-06-20 12:30:00', 1, 10.00, 2.10, 12.10, 2),
(10, 7, 10, 1, '2025-06-20 13:00:00', 1, 10.00, 2.10, 12.10, 2),
(11, 8, 21, 1, '2025-07-25 18:00:00', 1, 19.00, 3.99, 22.99, 2),
(12, 8, 22, 1, '2025-07-25 18:30:00', 2, 19.00, 3.99, 22.99, 2),
(13, 8, 23, 1, '2025-07-25 19:00:00', 1, 19.00, 3.99, 22.99, 2),
(14, 8, 24, 1, '2025-07-25 19:30:00', 1, 19.00, 3.99, 22.99, 2),
(15, 8, 25, 1, '2025-07-26 10:00:00', 2, 19.00, 3.99, 22.99, 2),
(1, 8, 26, 1, '2025-07-26 10:30:00', 1, 19.00, 3.99, 22.99, 2),
(2, 8, 27, 1, '2025-07-26 11:00:00', 1, 19.00, 3.99, 22.99, 2),
(3, 8, 28, 1, '2025-07-26 11:30:00', 2, 19.00, 3.99, 22.99, 2),
(4, 8, 29, 1, '2025-07-26 12:00:00', 1, 19.00, 3.99, 22.99, 2),
(5, 8, 30, 1, '2025-07-26 12:30:00', 1, 19.00, 3.99, 22.99, 2),
(6, 8, 31, 1, '2025-07-26 13:00:00', 2, 19.00, 3.99, 22.99, 2),
(7, 8, 32, 1, '2025-07-26 13:30:00', 1, 19.00, 3.99, 22.99, 2),
(8, 9, 81, 2, '2025-08-09 18:00:00', 1, 17.00, 3.57, 20.57, 2),
(9, 9, 82, 2, '2025-08-09 18:30:00', 2, 17.00, 3.57, 20.57, 2),
(10, 9, 83, 2, '2025-08-09 19:00:00', 1, 17.00, 3.57, 20.57, 2),
(11, 9, 84, 2, '2025-08-09 19:30:00', 1, 17.00, 3.57, 20.57, 2),
(12, 9, 85, 2, '2025-08-10 10:00:00', 2, 17.00, 3.57, 20.57, 2),
(13, 9, 86, 2, '2025-08-10 10:30:00', 1, 17.00, 3.57, 20.57, 2),
(14, 9, 87, 2, '2025-08-10 11:00:00', 1, 17.00, 3.57, 20.57, 2),
(15, 9, 88, 2, '2025-08-10 11:30:00', 2, 17.00, 3.57, 20.57, 2),
(1, 9, 89, 2, '2025-08-10 12:00:00', 1, 17.00, 3.57, 20.57, 2),
(2, 9, 90, 2, '2025-08-10 12:30:00', 1, 17.00, 3.57, 20.57, 2),
(3, 9, 91, 2, '2025-08-10 13:00:00', 2, 17.00, 3.57, 20.57, 2),
(4, 10, 21, 1, '2025-09-13 18:00:00', 1, 18.00, 3.78, 21.78, 2),
(5, 10, 22, 1, '2025-09-13 18:30:00', 2, 18.00, 3.78, 21.78, 2),
(6, 10, 23, 1, '2025-09-13 19:00:00', 1, 18.00, 3.78, 21.78, 2),
(7, 10, 24, 1, '2025-09-14 10:00:00', 1, 18.00, 3.78, 21.78, 2),
(8, 10, 25, 1, '2025-09-14 10:30:00', 2, 18.00, 3.78, 21.78, 2),
(9, 10, 26, 1, '2025-09-14 11:00:00', 1, 18.00, 3.78, 21.78, 2),
(10, 10, 27, 1, '2025-09-14 11:30:00', 1, 18.00, 3.78, 21.78, 2),
(11, 10, 28, 1, '2025-09-14 12:00:00', 2, 18.00, 3.78, 21.78, 2),
(12, 10, 29, 1, '2025-09-14 12:30:00', 1, 18.00, 3.78, 21.78, 2),
(13, 10, 30, 1, '2025-09-14 13:00:00', 1, 18.00, 3.78, 21.78, 2),
(14, 11, 21, 1, '2025-10-24 18:00:00', 1, 18.00, 3.78, 21.78, 2),
(15, 11, 22, 1, '2025-10-24 18:30:00', 2, 18.00, 3.78, 21.78, 2),
(1, 11, 23, 1, '2025-10-24 19:00:00', 1, 18.00, 3.78, 21.78, 2),
(2, 11, 24, 1, '2025-10-25 10:00:00', 1, 18.00, 3.78, 21.78, 2),
(3, 11, 25, 1, '2025-10-25 10:30:00', 2, 18.00, 3.78, 21.78, 2),
(4, 11, 26, 1, '2025-10-25 11:00:00', 1, 18.00, 3.78, 21.78, 2),
(5, 11, 27, 1, '2025-10-25 11:30:00', 1, 18.00, 3.78, 21.78, 2),
(6, 11, 28, 1, '2025-10-25 12:00:00', 2, 18.00, 3.78, 21.78, 2),
(7, 11, 29, 1, '2025-10-25 12:30:00', 1, 18.00, 3.78, 21.78, 2),
(8, 11, 30, 1, '2025-10-25 13:00:00', 1, 18.00, 3.78, 21.78, 2),
(9, 12, 41, 1, '2025-11-19 19:00:00', 1, 26.00, 5.46, 31.46, 2),
(10, 12, 42, 1, '2025-11-19 19:30:00', 2, 26.00, 5.46, 31.46, 2),
(11, 12, 43, 1, '2025-11-19 20:00:00', 1, 26.00, 5.46, 31.46, 2),
(12, 12, 44, 1, '2025-11-20 10:00:00', 1, 26.00, 5.46, 31.46, 2),
(13, 12, 45, 1, '2025-11-20 10:30:00', 2, 26.00, 5.46, 31.46, 2),
(14, 12, 46, 1, '2025-11-20 11:00:00', 1, 26.00, 5.46, 31.46, 2),
(15, 12, 47, 1, '2025-11-20 11:30:00', 1, 26.00, 5.46, 31.46, 2),
(1, 12, 48, 1, '2025-11-20 12:00:00', 2, 26.00, 5.46, 31.46, 2),
(2, 13, 1, 1, '2025-11-27 18:00:00', 1, 11.00, 2.31, 13.31, 2),
(3, 13, 2, 1, '2025-11-27 18:30:00', 2, 11.00, 2.31, 13.31, 2),
(4, 13, 3, 1, '2025-11-27 19:00:00', 1, 11.00, 2.31, 13.31, 2),
(5, 13, 4, 1, '2025-11-28 10:00:00', 1, 11.00, 2.31, 13.31, 2),
(6, 13, 5, 1, '2025-11-28 10:30:00', 2, 11.00, 2.31, 13.31, 2),
(7, 13, 6, 1, '2025-11-28 11:00:00', 1, 11.00, 2.31, 13.31, 2),
(8, 13, 7, 1, '2025-11-28 11:30:00', 1, 11.00, 2.31, 13.31, 2),
(9, 14, 61, 2, '2025-12-14 18:00:00', 1, 11.00, 2.31, 13.31, 2),
(10, 14, 62, 2, '2025-12-14 18:30:00', 2, 11.00, 2.31, 13.31, 2),
(11, 14, 63, 2, '2025-12-14 19:00:00', 1, 11.00, 2.31, 13.31, 2),
(12, 14, 64, 2, '2025-12-15 10:00:00', 1, 11.00, 2.31, 13.31, 2),
(13, 14, 65, 2, '2025-12-15 10:30:00', 2, 11.00, 2.31, 13.31, 2),
(14, 14, 66, 2, '2025-12-15 11:00:00', 1, 11.00, 2.31, 13.31, 2),
(15, 14, 67, 2, '2025-12-15 11:30:00', 1, 11.00, 2.31, 13.31, 2),
(1, 14, 68, 2, '2025-12-15 12:00:00', 2, 11.00, 2.31, 13.31, 2),
(2, 14, 69, 2, '2025-12-15 12:30:00', 1, 11.00, 2.31, 13.31, 2),
(3, 14, 70, 2, '2025-12-15 13:00:00', 1, 11.00, 2.31, 13.31, 2),
(1, 15, 81, 2, '2025-01-17 18:00:00', 1, 16.00, 3.36, 19.36, 2),
(2, 15, 82, 2, '2025-01-17 18:30:00', 2, 16.00, 3.36, 19.36, 2),
(3, 15, 83, 2, '2025-01-18 10:00:00', 1, 16.00, 3.36, 19.36, 2),
(4, 15, 84, 2, '2025-01-18 10:30:00', 1, 16.00, 3.36, 19.36, 2),
(5, 15, 85, 2, '2025-01-18 11:00:00', 2, 16.00, 3.36, 19.36, 2),
(6, 15, 86, 2, '2025-01-18 11:30:00', 1, 16.00, 3.36, 19.36, 2),
(7, 16, 121, 3, '2025-01-19 18:00:00', 1, 10.00, 2.10, 12.10, 2),
(8, 16, 122, 3, '2025-01-19 18:30:00', 2, 10.00, 2.10, 12.10, 2),
(9, 16, 123, 3, '2025-01-20 10:00:00', 1, 10.00, 2.10, 12.10, 2),
(10, 16, 124, 3, '2025-01-20 10:30:00', 1, 10.00, 2.10, 12.10, 2),
(11, 16, 125, 3, '2025-01-20 11:00:00', 2, 10.00, 2.10, 12.10, 2),
(12, 17, 121, 2, '2025-02-14 18:00:00', 1, 13.00, 2.73, 15.73, 2),
(13, 17, 122, 2, '2025-02-14 18:30:00', 2, 13.00, 2.73, 15.73, 2),
(14, 17, 123, 2, '2025-02-15 10:00:00', 1, 13.00, 2.73, 15.73, 2),
(15, 17, 124, 2, '2025-02-15 10:30:00', 1, 13.00, 2.73, 15.73, 2),
(1, 17, 125, 2, '2025-02-15 11:00:00', 2, 13.00, 2.73, 15.73, 2),
(2, 17, 126, 2, '2025-02-15 11:30:00', 1, 13.00, 2.73, 15.73, 2),
(3, 18, 141, 3, '2025-02-17 18:00:00', 1, 10.00, 2.10, 12.10, 2),
(4, 18, 142, 3, '2025-02-17 18:30:00', 2, 10.00, 2.10, 12.10, 2),
(5, 18, 143, 3, '2025-02-18 10:00:00', 1, 10.00, 2.10, 12.10, 2),
(6, 18, 144, 3, '2025-02-18 10:30:00', 1, 10.00, 2.10, 12.10, 2),
(7, 18, 145, 3, '2025-02-18 11:00:00', 2, 10.00, 2.10, 12.10, 2),
(8, 19, 87, 2, '2025-03-17 18:00:00', 1, 16.00, 3.36, 19.36, 2),
(9, 19, 88, 2, '2025-03-17 18:30:00', 2, 16.00, 3.36, 19.36, 2),
(10, 19, 89, 2, '2025-03-18 10:00:00', 1, 16.00, 3.36, 19.36, 2),
(11, 19, 90, 2, '2025-03-18 10:30:00', 1, 16.00, 3.36, 19.36, 2),
(12, 19, 91, 2, '2025-03-18 11:00:00', 2, 16.00, 3.36, 19.36, 2),
(13, 19, 92, 2, '2025-03-18 11:30:00', 1, 16.00, 3.36, 19.36, 2),
(14, 19, 93, 2, '2025-03-18 12:00:00', 1, 16.00, 3.36, 19.36, 2),
(15, 20, 121, 3, '2025-03-21 18:00:00', 1, 10.00, 2.10, 12.10, 2),
(1, 20, 122, 3, '2025-03-21 18:30:00', 2, 10.00, 2.10, 12.10, 2),
(2, 20, 123, 3, '2025-03-22 10:00:00', 1, 10.00, 2.10, 12.10, 2),
(3, 20, 124, 3, '2025-03-22 10:30:00', 1, 10.00, 2.10, 12.10, 2),
(4, 20, 125, 3, '2025-03-22 11:00:00', 2, 10.00, 2.10, 12.10, 2),
(5, 20, 126, 3, '2025-03-22 11:30:00', 1, 10.00, 2.10, 12.10, 2),
(6, 21, 127, 2, '2025-04-19 13:00:00', 1, 11.00, 2.31, 13.31, 2),
(7, 21, 128, 2, '2025-04-19 13:30:00', 2, 11.00, 2.31, 13.31, 2),
(8, 21, 129, 2, '2025-04-20 10:00:00', 1, 11.00, 2.31, 13.31, 2),
(9, 21, 130, 2, '2025-04-20 10:30:00', 1, 11.00, 2.31, 13.31, 2),
(10, 21, 131, 2, '2025-04-20 11:00:00', 2, 11.00, 2.31, 13.31, 2),
(11, 21, 132, 2, '2025-04-20 11:30:00', 1, 11.00, 2.31, 13.31, 2),
(12, 22, 141, 3, '2025-04-21 13:00:00', 1, 9.00, 1.89, 10.89, 2),
(13, 22, 142, 3, '2025-04-21 13:30:00', 2, 9.00, 1.89, 10.89, 2),
(14, 22, 143, 3, '2025-04-22 10:00:00', 1, 9.00, 1.89, 10.89, 2),
(15, 22, 144, 3, '2025-04-22 10:30:00', 1, 9.00, 1.89, 10.89, 2),
(1, 22, 145, 3, '2025-04-22 11:00:00', 2, 9.00, 1.89, 10.89, 2),
(2, 23, 121, 3, '2025-05-14 13:00:00', 1, 10.00, 2.10, 12.10, 2),
(3, 23, 122, 3, '2025-05-14 13:30:00', 2, 10.00, 2.10, 12.10, 2),
(4, 23, 123, 3, '2025-05-15 10:00:00', 1, 10.00, 2.10, 12.10, 2),
(5, 23, 124, 3, '2025-05-15 10:30:00', 1, 10.00, 2.10, 12.10, 2),
(6, 23, 125, 3, '2025-05-15 11:00:00', 2, 10.00, 2.10, 12.10, 2),
(7, 24, 81, 2, '2025-06-24 13:00:00', 1, 10.00, 2.10, 12.10, 2),
(8, 24, 82, 2, '2025-06-24 13:30:00', 2, 10.00, 2.10, 12.10, 2),
(9, 24, 83, 2, '2025-06-25 10:00:00', 1, 10.00, 2.10, 12.10, 2),
(10, 24, 84, 2, '2025-06-25 10:30:00', 1, 10.00, 2.10, 12.10, 2),
(11, 24, 85, 2, '2025-06-25 11:00:00', 2, 10.00, 2.10, 12.10, 2),
(12, 24, 86, 2, '2025-06-25 11:30:00', 1, 10.00, 2.10, 12.10, 2),
(13, 25, 141, 3, '2025-06-26 13:00:00', 1, 9.00, 1.89, 10.89, 2),
(14, 25, 142, 3, '2025-06-26 13:30:00', 2, 9.00, 1.89, 10.89, 2),
(15, 25, 143, 3, '2025-06-27 10:00:00', 1, 9.00, 1.89, 10.89, 2),
(1, 25, 144, 3, '2025-06-27 10:30:00', 1, 9.00, 1.89, 10.89, 2),
(2, 25, 145, 3, '2025-06-27 11:00:00', 2, 9.00, 1.89, 10.89, 2),
(3, 26, 127, 2, '2025-07-27 18:00:00', 1, 14.00, 2.94, 16.94, 2),
(4, 26, 128, 2, '2025-07-27 18:30:00', 2, 14.00, 2.94, 16.94, 2),
(5, 26, 129, 2, '2025-07-28 10:00:00', 1, 14.00, 2.94, 16.94, 2),
(6, 26, 130, 2, '2025-07-28 10:30:00', 1, 14.00, 2.94, 16.94, 2),
(7, 26, 131, 2, '2025-07-28 11:00:00', 2, 14.00, 2.94, 16.94, 2),
(8, 26, 132, 2, '2025-07-28 11:30:00', 1, 14.00, 2.94, 16.94, 2),
(9, 27, 121, 3, '2025-07-29 18:00:00', 1, 11.00, 2.31, 13.31, 2),
(10, 27, 122, 3, '2025-07-29 18:30:00', 2, 11.00, 2.31, 13.31, 2),
(11, 27, 123, 3, '2025-07-30 10:00:00', 1, 11.00, 2.31, 13.31, 2),
(12, 27, 124, 3, '2025-07-30 10:30:00', 1, 11.00, 2.31, 13.31, 2),
(13, 27, 125, 3, '2025-07-30 11:00:00', 2, 11.00, 2.31, 13.31, 2),
(14, 28, 141, 3, '2025-08-14 18:00:00', 1, 11.00, 2.31, 13.31, 2),
(15, 28, 142, 3, '2025-08-14 18:30:00', 2, 11.00, 2.31, 13.31, 2),
(1, 28, 143, 3, '2025-08-15 10:00:00', 1, 11.00, 2.31, 13.31, 2),
(2, 28, 144, 3, '2025-08-15 10:30:00', 1, 11.00, 2.31, 13.31, 2),
(3, 28, 145, 3, '2025-08-15 11:00:00', 2, 11.00, 2.31, 13.31, 2),
(4, 28, 146, 3, '2025-08-15 11:30:00', 1, 11.00, 2.31, 13.31, 2),
(5, 29, 87, 2, '2025-09-17 18:00:00', 1, 16.00, 3.36, 19.36, 2),
(6, 29, 88, 2, '2025-09-17 18:30:00', 2, 16.00, 3.36, 19.36, 2),
(7, 29, 89, 2, '2025-09-18 10:00:00', 1, 16.00, 3.36, 19.36, 2),
(8, 29, 90, 2, '2025-09-18 10:30:00', 1, 16.00, 3.36, 19.36, 2),
(9, 29, 91, 2, '2025-09-18 11:00:00', 2, 16.00, 3.36, 19.36, 2),
(10, 29, 92, 2, '2025-09-18 11:30:00', 1, 16.00, 3.36, 19.36, 2),
(11, 30, 121, 3, '2025-09-19 18:00:00', 1, 11.00, 2.31, 13.31, 2),
(12, 30, 122, 3, '2025-09-19 18:30:00', 2, 11.00, 2.31, 13.31, 2),
(13, 30, 123, 3, '2025-09-20 10:00:00', 1, 11.00, 2.31, 13.31, 2),
(14, 30, 124, 3, '2025-09-20 10:30:00', 1, 11.00, 2.31, 13.31, 2),
(15, 30, 125, 3, '2025-09-20 11:00:00', 2, 11.00, 2.31, 13.31, 2),
(1, 31, 127, 2, '2025-10-27 18:00:00', 1, 13.00, 2.73, 15.73, 2),
(2, 31, 128, 2, '2025-10-27 18:30:00', 2, 13.00, 2.73, 15.73, 2),
(3, 31, 129, 2, '2025-10-28 10:00:00', 1, 13.00, 2.73, 15.73, 2),
(4, 31, 130, 2, '2025-10-28 10:30:00', 1, 13.00, 2.73, 15.73, 2),
(5, 31, 131, 2, '2025-10-28 11:00:00', 2, 13.00, 2.73, 15.73, 2),
(6, 31, 132, 2, '2025-10-28 11:30:00', 1, 13.00, 2.73, 15.73, 2),
(7, 32, 141, 3, '2025-10-29 18:00:00', 1, 11.00, 2.31, 13.31, 2),
(8, 32, 142, 3, '2025-10-29 18:30:00', 2, 11.00, 2.31, 13.31, 2),
(9, 32, 143, 3, '2025-10-30 10:00:00', 1, 11.00, 2.31, 13.31, 2),
(10, 32, 144, 3, '2025-10-30 10:30:00', 1, 11.00, 2.31, 13.31, 2),
(11, 32, 145, 3, '2025-10-30 11:00:00', 2, 11.00, 2.31, 13.31, 2),
(12, 33, 81, 2, '2025-11-24 18:00:00', 1, 17.00, 3.57, 20.57, 2),
(13, 33, 82, 2, '2025-11-24 18:30:00', 2, 17.00, 3.57, 20.57, 2),
(14, 33, 83, 2, '2025-11-25 10:00:00', 1, 17.00, 3.57, 20.57, 2),
(15, 33, 84, 2, '2025-11-25 10:30:00', 1, 17.00, 3.57, 20.57, 2),
(1, 33, 85, 2, '2025-11-25 11:00:00', 2, 17.00, 3.57, 20.57, 2),
(2, 33, 86, 2, '2025-11-25 11:30:00', 1, 17.00, 3.57, 20.57, 2),
(3, 34, 121, 3, '2025-11-26 18:00:00', 1, 10.00, 2.10, 12.10, 2),
(4, 34, 122, 3, '2025-11-26 18:30:00', 2, 10.00, 2.10, 12.10, 2),
(5, 34, 123, 3, '2025-11-27 10:00:00', 1, 10.00, 2.10, 12.10, 2),
(6, 34, 124, 3, '2025-11-27 10:30:00', 1, 10.00, 2.10, 12.10, 2),
(7, 34, 125, 3, '2025-11-27 11:00:00', 2, 10.00, 2.10, 12.10, 2),
(8, 35, 141, 3, '2025-12-19 18:00:00', 1, 10.00, 2.10, 12.10, 2),
(9, 35, 142, 3, '2025-12-19 18:30:00', 2, 10.00, 2.10, 12.10, 2),
(10, 35, 143, 3, '2025-12-20 10:00:00', 1, 10.00, 2.10, 12.10, 2),
(11, 35, 144, 3, '2025-12-20 10:30:00', 1, 10.00, 2.10, 12.10, 2),
(12, 35, 145, 3, '2025-12-20 11:00:00', 2, 10.00, 2.10, 12.10, 2);

INSERT INTO shop_ticket (Location_ID, Customer_ID, Purchase_DateTime, Payment_Method_ID, Total_Product, Total_Tax, Total_Order) VALUES
(1, 1, '2025-01-14 19:00:00', 1, 13.50, 2.84, 16.34),
(1, 3, '2025-01-14 19:30:00', 2, 10.00, 2.10, 12.10),
(1, 5, '2025-01-15 10:30:00', 1, 13.50, 2.84, 16.34),
(1, 7, '2025-01-15 11:00:00', 3, 9.50, 2.00, 11.50),
(1, 9, '2025-01-15 12:00:00', 1, 8.00, 1.68, 9.68),
(1, 11, '2025-01-15 13:00:00', 2, 5.50, 1.16, 6.66),
(1, 2, '2025-01-14 19:15:00', 1, 7.50, 1.58, 9.08),
(1, 13, '2025-02-11 19:00:00', 1, 13.50, 2.84, 16.34),
(1, 15, '2025-02-11 20:00:00', 2, 10.00, 2.10, 12.10),
(1, 2, '2025-02-12 10:30:00', 1, 12.00, 2.52, 14.52),
(1, 4, '2025-02-12 11:30:00', 3, 9.50, 2.00, 11.50),
(1, 6, '2025-02-12 12:30:00', 1, 6.50, 1.37, 7.87),
(1, 1, '2025-02-11 18:30:00', 2, 4.00, 0.84, 4.84),
(1, 8, '2025-03-14 19:00:00', 1, 13.50, 2.84, 16.34),
(1, 10, '2025-03-14 19:30:00', 2, 13.50, 2.84, 16.34),
(1, 12, '2025-03-14 20:00:00', 1, 10.00, 2.10, 12.10),
(1, 14, '2025-03-15 10:30:00', 3, 12.00, 2.52, 14.52),
(1, 1, '2025-03-15 11:30:00', 1, 13.50, 2.84, 16.34),
(1, 3, '2025-03-15 12:30:00', 2, 10.00, 2.10, 12.10),
(1, 5, '2025-03-15 13:00:00', 1, 9.50, 2.00, 11.50),
(1, 9, '2025-03-19 20:00:00', 1, 13.50, 2.84, 16.34),
(1, 11, '2025-03-20 10:30:00', 2, 8.00, 1.68, 9.68),
(1, 6, '2025-03-14 18:30:00', 1, 5.50, 1.16, 6.66),
(1, 7, '2025-03-19 19:30:00', 3, 7.50, 1.58, 9.08),
(1, 4, '2025-03-15 12:00:00', 1, 6.50, 1.37, 7.87),
(1, 13, '2025-04-17 15:00:00', 1, 10.00, 2.10, 12.10),
(1, 15, '2025-04-18 10:30:00', 2, 13.50, 2.84, 16.34),
(1, 2, '2025-04-18 11:30:00', 1, 9.50, 2.00, 11.50),
(1, 4, '2025-04-18 12:30:00', 3, 12.00, 2.52, 14.52),
(1, 6, '2025-04-18 13:00:00', 1, 8.00, 1.68, 9.68),
(1, 1, '2025-04-17 14:30:00', 2, 4.00, 0.84, 4.84),
(2, 8, '2025-05-09 14:00:00', 1, 10.00, 2.10, 12.10),
(2, 10, '2025-05-10 10:30:00', 2, 13.50, 2.84, 16.34),
(2, 12, '2025-05-10 11:30:00', 1, 9.50, 2.00, 11.50),
(2, 14, '2025-05-10 12:00:00', 3, 7.50, 1.58, 9.08),
(2, 9, '2025-05-09 13:30:00', 1, 5.50, 1.16, 6.66),
(1, 1, '2025-06-19 15:00:00', 1, 13.50, 2.84, 16.34),
(1, 3, '2025-06-20 10:30:00', 2, 10.00, 2.10, 12.10),
(1, 5, '2025-06-20 11:30:00', 1, 12.00, 2.52, 14.52),
(1, 7, '2025-06-20 12:30:00', 3, 9.50, 2.00, 11.50),
(1, 9, '2025-06-20 13:00:00', 1, 8.00, 1.68, 9.68),
(1, 2, '2025-06-19 14:30:00', 2, 6.50, 1.37, 7.87),
(1, 11, '2025-07-25 19:00:00', 1, 13.50, 2.84, 16.34),
(1, 13, '2025-07-26 10:30:00', 2, 13.50, 2.84, 16.34),
(1, 15, '2025-07-26 11:30:00', 1, 10.00, 2.10, 12.10),
(1, 2, '2025-07-26 12:30:00', 3, 9.50, 2.00, 11.50),
(1, 4, '2025-07-26 13:00:00', 1, 5.50, 1.16, 6.66),
(1, 6, '2025-07-25 18:30:00', 2, 7.50, 1.58, 9.08),
(1, 1, '2025-07-26 13:30:00', 1, 8.00, 1.68, 9.68),
(2, 8, '2025-08-09 19:00:00', 1, 10.00, 2.10, 12.10),
(2, 10, '2025-08-10 10:30:00', 2, 13.50, 2.84, 16.34),
(2, 12, '2025-08-10 11:30:00', 1, 12.00, 2.52, 14.52),
(2, 14, '2025-08-10 12:30:00', 3, 9.50, 2.00, 11.50),
(2, 1, '2025-08-10 13:00:00', 1, 4.00, 0.84, 4.84),
(2, 3, '2025-08-09 18:30:00', 2, 8.00, 1.68, 9.68),
(2, 9, '2025-08-09 19:30:00', 1, 6.50, 1.37, 7.87),
(1, 4, '2025-09-13 19:00:00', 1, 13.50, 2.84, 16.34),
(1, 6, '2025-09-14 10:30:00', 2, 10.00, 2.10, 12.10),
(1, 8, '2025-09-14 11:30:00', 1, 9.50, 2.00, 11.50),
(1, 10, '2025-09-14 12:30:00', 3, 12.00, 2.52, 14.52),
(1, 12, '2025-09-14 13:00:00', 1, 5.50, 1.16, 6.66),
(1, 5, '2025-09-13 18:30:00', 2, 7.50, 1.58, 9.08),
(1, 14, '2025-10-24 19:00:00', 1, 13.50, 2.84, 16.34),
(1, 1, '2025-10-25 10:30:00', 2, 10.00, 2.10, 12.10),
(1, 3, '2025-10-25 11:30:00', 1, 12.00, 2.52, 14.52),
(1, 5, '2025-10-25 12:30:00', 3, 9.50, 2.00, 11.50),
(1, 7, '2025-10-25 13:00:00', 1, 8.00, 1.68, 9.68),
(1, 15, '2025-10-24 18:30:00', 2, 6.50, 1.37, 7.87),
(1, 9, '2025-11-19 20:00:00', 1, 13.50, 2.84, 16.34),
(1, 11, '2025-11-20 10:30:00', 2, 13.50, 2.84, 16.34),
(1, 13, '2025-11-20 11:30:00', 1, 10.00, 2.10, 12.10),
(1, 15, '2025-11-20 12:00:00', 3, 9.50, 2.00, 11.50),
(1, 2, '2025-11-27 19:00:00', 1, 12.00, 2.52, 14.52),
(1, 4, '2025-11-28 10:30:00', 2, 8.00, 1.68, 9.68),
(1, 6, '2025-11-28 11:00:00', 1, 5.50, 1.16, 6.66),
(1, 8, '2025-11-28 11:30:00', 3, 7.50, 1.58, 9.08),
(1, 10, '2025-11-19 19:30:00', 1, 4.00, 0.84, 4.84),
(2, 9, '2025-12-14 19:00:00', 1, 10.00, 2.10, 12.10),
(2, 11, '2025-12-15 10:30:00', 2, 13.50, 2.84, 16.34),
(2, 13, '2025-12-15 11:30:00', 1, 9.50, 2.00, 11.50),
(2, 15, '2025-12-15 12:30:00', 3, 12.00, 2.52, 14.52),
(2, 1, '2025-12-15 13:00:00', 1, 8.00, 1.68, 9.68),
(2, 10, '2025-12-14 18:30:00', 2, 7.50, 1.58, 9.08),
(2, 1, '2025-01-17 19:00:00', 1, 10.00, 2.10, 12.10),
(3, 7, '2025-01-19 19:00:00', 2, 9.50, 2.00, 11.50),
(2, 12, '2025-02-14 19:00:00', 1, 13.50, 2.84, 16.34),
(3, 3, '2025-02-17 19:00:00', 3, 10.00, 2.10, 12.10),
(2, 8, '2025-03-17 19:00:00', 1, 12.00, 2.52, 14.52),
(3, 15, '2025-03-21 19:00:00', 2, 9.50, 2.00, 11.50),
(2, 6, '2025-04-19 14:00:00', 1, 10.00, 2.10, 12.10),
(3, 12, '2025-04-21 14:00:00', 3, 7.50, 1.58, 9.08),
(3, 2, '2025-05-14 14:00:00', 1, 9.50, 2.00, 11.50),
(2, 7, '2025-06-24 14:00:00', 2, 13.50, 2.84, 16.34),
(3, 13, '2025-06-26 14:00:00', 1, 7.50, 1.58, 9.08),
(2, 3, '2025-07-27 19:00:00', 1, 10.00, 2.10, 12.10),
(3, 9, '2025-07-29 19:00:00', 2, 9.50, 2.00, 11.50),
(3, 14, '2025-08-14 19:00:00', 1, 10.00, 2.10, 12.10),
(2, 5, '2025-09-17 19:00:00', 2, 12.00, 2.52, 14.52),
(3, 11, '2025-09-19 19:00:00', 1, 9.50, 2.00, 11.50),
(2, 1, '2025-10-27 19:00:00', 1, 13.50, 2.84, 16.34),
(3, 7, '2025-10-29 19:00:00', 3, 10.00, 2.10, 12.10),
(2, 12, '2025-11-24 19:00:00', 1, 12.00, 2.52, 14.52),
(3, 3, '2025-11-26 19:00:00', 2, 9.50, 2.00, 11.50),
(3, 8, '2025-12-19 19:00:00', 1, 10.00, 2.10, 12.10);

INSERT INTO shop_item (Shop_Ticket_ID, NumSeq, Product_ID, Quantity, Price, Tax_Amount, Line_Total) VALUES
(1, 1, 3, 1, 8.00, 1.68, 9.68), (1, 2, 6, 1, 5.50, 1.16, 6.66),
(2, 1, 2, 1, 6.00, 1.26, 7.26), (2, 2, 5, 1, 4.00, 0.84, 4.84),
(3, 1, 3, 1, 8.00, 1.68, 9.68), (3, 2, 6, 1, 5.50, 1.16, 6.66),
(4, 1, 2, 1, 6.00, 1.26, 7.26), (4, 2, 4, 1, 3.00, 0.63, 3.63),
(5, 1, 3, 1, 8.00, 1.68, 9.68),
(6, 1, 6, 1, 5.50, 1.16, 6.66),
(7, 1, 8, 1, 4.00, 0.84, 4.84), (7, 2, 9, 1, 3.50, 0.74, 4.24),
(8, 1, 3, 1, 8.00, 1.68, 9.68), (8, 2, 6, 1, 5.50, 1.16, 6.66),
(9, 1, 2, 1, 6.00, 1.26, 7.26), (9, 2, 5, 1, 4.00, 0.84, 4.84),
(10, 1, 3, 1, 8.00, 1.68, 9.68), (10, 2, 5, 1, 4.00, 0.84, 4.84),
(11, 1, 2, 1, 6.00, 1.26, 7.26), (11, 2, 4, 1, 3.00, 0.63, 3.63),
(12, 1, 10, 1, 6.50, 1.37, 7.87),
(13, 1, 8, 1, 4.00, 0.84, 4.84),
(14, 1, 3, 1, 8.00, 1.68, 9.68), (14, 2, 6, 1, 5.50, 1.16, 6.66),
(15, 1, 3, 1, 8.00, 1.68, 9.68), (15, 2, 6, 1, 5.50, 1.16, 6.66),
(16, 1, 2, 1, 6.00, 1.26, 7.26), (16, 2, 5, 1, 4.00, 0.84, 4.84),
(17, 1, 3, 1, 8.00, 1.68, 9.68), (17, 2, 5, 1, 4.00, 0.84, 4.84),
(18, 1, 3, 1, 8.00, 1.68, 9.68), (18, 2, 6, 1, 5.50, 1.16, 6.66),
(19, 1, 2, 1, 6.00, 1.26, 7.26), (19, 2, 5, 1, 4.00, 0.84, 4.84),
(20, 1, 2, 1, 6.00, 1.26, 7.26), (20, 2, 4, 1, 3.00, 0.63, 3.63),
(21, 1, 3, 1, 8.00, 1.68, 9.68), (21, 2, 6, 1, 5.50, 1.16, 6.66),
(22, 1, 3, 1, 8.00, 1.68, 9.68),
(23, 1, 6, 1, 5.50, 1.16, 6.66),
(24, 1, 8, 1, 4.00, 0.84, 4.84), (24, 2, 9, 1, 3.50, 0.74, 4.24),
(25, 1, 10, 1, 6.50, 1.37, 7.87),
(26, 1, 2, 1, 6.00, 1.26, 7.26), (26, 2, 5, 1, 4.00, 0.84, 4.84),
(27, 1, 3, 1, 8.00, 1.68, 9.68), (27, 2, 6, 1, 5.50, 1.16, 6.66),
(28, 1, 2, 1, 6.00, 1.26, 7.26), (28, 2, 4, 1, 3.00, 0.63, 3.63),
(29, 1, 3, 1, 8.00, 1.68, 9.68), (29, 2, 5, 1, 4.00, 0.84, 4.84),
(30, 1, 3, 1, 8.00, 1.68, 9.68),
(31, 1, 8, 1, 4.00, 0.84, 4.84),
(32, 1, 2, 1, 6.00, 1.26, 7.26), (32, 2, 5, 1, 4.00, 0.84, 4.84),
(33, 1, 3, 1, 8.00, 1.68, 9.68), (33, 2, 6, 1, 5.50, 1.16, 6.66),
(34, 1, 2, 1, 6.00, 1.26, 7.26), (34, 2, 4, 1, 3.00, 0.63, 3.63),
(35, 1, 8, 1, 4.00, 0.84, 4.84), (35, 2, 9, 1, 3.50, 0.74, 4.24),
(36, 1, 6, 1, 5.50, 1.16, 6.66),
(37, 1, 3, 1, 8.00, 1.68, 9.68), (37, 2, 6, 1, 5.50, 1.16, 6.66),
(38, 1, 2, 1, 6.00, 1.26, 7.26), (38, 2, 5, 1, 4.00, 0.84, 4.84),
(39, 1, 3, 1, 8.00, 1.68, 9.68), (39, 2, 5, 1, 4.00, 0.84, 4.84),
(40, 1, 2, 1, 6.00, 1.26, 7.26), (40, 2, 4, 1, 3.00, 0.63, 3.63),
(41, 1, 3, 1, 8.00, 1.68, 9.68),
(42, 1, 10, 1, 6.50, 1.37, 7.87),
(43, 1, 3, 1, 8.00, 1.68, 9.68), (43, 2, 6, 1, 5.50, 1.16, 6.66),
(44, 1, 3, 1, 8.00, 1.68, 9.68), (44, 2, 6, 1, 5.50, 1.16, 6.66),
(45, 1, 2, 1, 6.00, 1.26, 7.26), (45, 2, 5, 1, 4.00, 0.84, 4.84),
(46, 1, 2, 1, 6.00, 1.26, 7.26), (46, 2, 4, 1, 3.00, 0.63, 3.63),
(47, 1, 6, 1, 5.50, 1.16, 6.66),
(48, 1, 8, 1, 4.00, 0.84, 4.84), (48, 2, 9, 1, 3.50, 0.74, 4.24),
(49, 1, 3, 1, 8.00, 1.68, 9.68),
(50, 1, 2, 1, 6.00, 1.26, 7.26), (50, 2, 5, 1, 4.00, 0.84, 4.84),
(51, 1, 3, 1, 8.00, 1.68, 9.68), (51, 2, 6, 1, 5.50, 1.16, 6.66),
(52, 1, 3, 1, 8.00, 1.68, 9.68), (52, 2, 5, 1, 4.00, 0.84, 4.84),
(53, 1, 2, 1, 6.00, 1.26, 7.26), (53, 2, 4, 1, 3.00, 0.63, 3.63),
(54, 1, 8, 1, 4.00, 0.84, 4.84),
(55, 1, 3, 1, 8.00, 1.68, 9.68),
(56, 1, 10, 1, 6.50, 1.37, 7.87),
(57, 1, 3, 1, 8.00, 1.68, 9.68), (57, 2, 6, 1, 5.50, 1.16, 6.66),
(58, 1, 2, 1, 6.00, 1.26, 7.26), (58, 2, 5, 1, 4.00, 0.84, 4.84),
(59, 1, 2, 1, 6.00, 1.26, 7.26), (59, 2, 4, 1, 3.00, 0.63, 3.63),
(60, 1, 3, 1, 8.00, 1.68, 9.68), (60, 2, 5, 1, 4.00, 0.84, 4.84),
(61, 1, 6, 1, 5.50, 1.16, 6.66),
(62, 1, 8, 1, 4.00, 0.84, 4.84), (62, 2, 9, 1, 3.50, 0.74, 4.24),
(63, 1, 3, 1, 8.00, 1.68, 9.68), (63, 2, 6, 1, 5.50, 1.16, 6.66),
(64, 1, 2, 1, 6.00, 1.26, 7.26), (64, 2, 5, 1, 4.00, 0.84, 4.84),
(65, 1, 3, 1, 8.00, 1.68, 9.68), (65, 2, 5, 1, 4.00, 0.84, 4.84),
(66, 1, 2, 1, 6.00, 1.26, 7.26), (66, 2, 4, 1, 3.00, 0.63, 3.63),
(67, 1, 3, 1, 8.00, 1.68, 9.68),
(68, 1, 10, 1, 6.50, 1.37, 7.87),
(69, 1, 3, 1, 8.00, 1.68, 9.68), (69, 2, 6, 1, 5.50, 1.16, 6.66),
(70, 1, 3, 1, 8.00, 1.68, 9.68), (70, 2, 6, 1, 5.50, 1.16, 6.66),
(71, 1, 2, 1, 6.00, 1.26, 7.26), (71, 2, 5, 1, 4.00, 0.84, 4.84),
(72, 1, 2, 1, 6.00, 1.26, 7.26), (72, 2, 4, 1, 3.00, 0.63, 3.63),
(73, 1, 3, 1, 8.00, 1.68, 9.68), (73, 2, 5, 1, 4.00, 0.84, 4.84),
(74, 1, 3, 1, 8.00, 1.68, 9.68),
(75, 1, 6, 1, 5.50, 1.16, 6.66),
(76, 1, 8, 1, 4.00, 0.84, 4.84), (76, 2, 9, 1, 3.50, 0.74, 4.24),
(77, 1, 8, 1, 4.00, 0.84, 4.84),
(78, 1, 2, 1, 6.00, 1.26, 7.26), (78, 2, 5, 1, 4.00, 0.84, 4.84),
(79, 1, 3, 1, 8.00, 1.68, 9.68), (79, 2, 6, 1, 5.50, 1.16, 6.66),
(80, 1, 2, 1, 6.00, 1.26, 7.26), (80, 2, 4, 1, 3.00, 0.63, 3.63),
(81, 1, 3, 1, 8.00, 1.68, 9.68), (81, 2, 5, 1, 4.00, 0.84, 4.84),
(82, 1, 3, 1, 8.00, 1.68, 9.68),
(83, 1, 8, 1, 4.00, 0.84, 4.84), (83, 2, 9, 1, 3.50, 0.74, 4.24),
(84, 1, 2, 1, 6.00, 1.26, 7.26), (84, 2, 5, 1, 4.00, 0.84, 4.84),
(85, 1, 2, 1, 6.00, 1.26, 7.26), (85, 2, 4, 1, 3.00, 0.63, 3.63),
(86, 1, 3, 1, 8.00, 1.68, 9.68), (86, 2, 6, 1, 5.50, 1.16, 6.66),
(87, 1, 2, 1, 6.00, 1.26, 7.26), (87, 2, 5, 1, 4.00, 0.84, 4.84),
(88, 1, 3, 1, 8.00, 1.68, 9.68), (88, 2, 5, 1, 4.00, 0.84, 4.84),
(89, 1, 2, 1, 6.00, 1.26, 7.26), (89, 2, 4, 1, 3.00, 0.63, 3.63),
(90, 1, 2, 1, 6.00, 1.26, 7.26), (90, 2, 5, 1, 4.00, 0.84, 4.84),
(91, 1, 8, 1, 4.00, 0.84, 4.84), (91, 2, 9, 1, 3.50, 0.74, 4.24),
(92, 1, 2, 1, 6.00, 1.26, 7.26), (92, 2, 4, 1, 3.00, 0.63, 3.63),
(93, 1, 3, 1, 8.00, 1.68, 9.68), (93, 2, 6, 1, 5.50, 1.16, 6.66),
(94, 1, 8, 1, 4.00, 0.84, 4.84), (94, 2, 9, 1, 3.50, 0.74, 4.24),
(95, 1, 2, 1, 6.00, 1.26, 7.26), (95, 2, 5, 1, 4.00, 0.84, 4.84),
(96, 1, 2, 1, 6.00, 1.26, 7.26), (96, 2, 4, 1, 3.00, 0.63, 3.63),
(97, 1, 2, 1, 6.00, 1.26, 7.26), (97, 2, 5, 1, 4.00, 0.84, 4.84),
(98, 1, 3, 1, 8.00, 1.68, 9.68), (98, 2, 5, 1, 4.00, 0.84, 4.84),
(99, 1, 2, 1, 6.00, 1.26, 7.26), (99, 2, 4, 1, 3.00, 0.63, 3.63),
(100, 1, 3, 1, 8.00, 1.68, 9.68), (100, 2, 6, 1, 5.50, 1.16, 6.66),
(101, 1, 2, 1, 6.00, 1.26, 7.26), (101, 2, 5, 1, 4.00, 0.84, 4.84),
(102, 1, 3, 1, 8.00, 1.68, 9.68), (102, 2, 5, 1, 4.00, 0.84, 4.84),
(103, 1, 2, 1, 6.00, 1.26, 7.26), (103, 2, 4, 1, 3.00, 0.63, 3.63),
(104, 1, 2, 1, 6.00, 1.26, 7.26), (104, 2, 5, 1, 4.00, 0.84, 4.84);
