SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE customer (id INTEGER PRIMARY KEY, name TEXT, account INT); INSERT INTO customer VALUES (1, "Caitlin", 123456); INSERT INTO customer VALUES (2, "Bella", 6655656); CREATE TABLE game (id INTEGER PRIMARY KEY, date DATE, day TEXT, time TIME, opponent TEXT); INSERT INTO game VALUES (1, "2023-02-14", "Saturday", "07:00:00", "Angels"); INSERT INTO game VALUES (2, "2023-02-15", "Sunday", "07:00:00", "Padres"); INSERT INTO game VALUES (3, "2023-02-15", "Sunday", "12:00:00", "Padres"); CREATE TABLE ticket (id INTEGER PRIMARY KEY, customer_id INT, game_id INT, seat INT, price INT, date_purchased TIMESTAMP); INSERT INTO ticket VALUES (1, 1, 1, 01234, 100, "2023-02-03 10:00:00"); INSERT INTO ticket VALUES (2, 1, 1, 234, 300, "2023-02-03 09:00:00"); INSERT INTO ticket VALUES (3, 1, 2, 1441234, 70, "2023-02-04 10:00:00"); INSERT INTO ticket VALUES (4, 2, 2, 34, 90, "2023-02-01 11:00:00"); INSERT INTO ticket VALUES (5, 2, 3, 124, 150, "2023-02-03 12:00:00"); SELECT DISTINCT opponent FROM game WHERE day = "Saturday" or day = "Sunday";