CREATE TABLE Comics (
    ComicID         INT PRIMARY KEY,
    Title           VARCHAR(150),
    YearsPublished  INT,
    Publisher       VARCHAR(100),
    Volume          INT
);

CREATE TABLE Movies (
    MovieID     INT PRIMARY KEY,
    Title       VARCHAR(150),
    ReleaseYear INT,
    Director    VARCHAR(100),
    Universe    VARCHAR(50), 
    Outcome     VARCHAR(50)
);

CREATE TABLE Actors (
    ActorID              INT PRIMARY KEY,
    Name                 VARCHAR(100),
    FirstAppearanceYear  INT,
    Medium               VARCHAR(50)
);

CREATE TABLE ActorMovies (
    ActorID   INT,
    MovieID   INT,
    Role      VARCHAR(100),
    FOREIGN KEY (ActorID) REFERENCES Actors(ActorID) ON DELETE CASCADE,
    FOREIGN KEY (MovieID) REFERENCES Movies(MovieID) ON DELETE CASCADE
);

CREATE TABLE Projects (
    ProjectID     INT PRIMARY KEY,
    Title         VARCHAR(150),
    ReleaseYear   INT,
    Medium        VARCHAR(100)
);

CREATE TABLE ActorProjects (
    ActorID    INT,
    ProjectID  INT,
    FOREIGN KEY (ActorID) REFERENCES Actors(ActorID) ON DELETE CASCADE,
    FOREIGN KEY (ProjectID) REFERENCES Projects(ProjectID) ON DELETE CASCADE
);

INSERT INTO Comics VALUES
    (1, 'Action Comics #1',           1938, 'DC Comics', 1),
    (2, 'Superman: Red Son',          2003, 'DC Comics', 1),
    (3, 'Superman: Birthright',       2003, 'DC Comics', 1),
    (4, 'The Death of Superman',      1992, 'DC Comics', 1),
    (5, 'Superman: Son of Kal-El',    2021, 'DC Comics', 1);

INSERT INTO Movies (MovieID, Title, ReleaseYear, Director, Universe, Outcome)
VALUES
    (1, 'Superman (1978)', 1978, 'Richard Donner', 'Original', 'Success'),
    (2, 'Superman II', 1980, 'Richard Lester', 'Original', 'Success'),
    (3, 'Superman Returns', 2006, 'Bryan Singer', 'Original', 'Flop'),
    (4, 'Man of Steel', 2013, 'Zack Snyder', 'DCEU', 'Success'),
    (5, 'Batman v Superman: Dawn of Justice', 2016, 'Zack Snyder', 'DCEU', 'Flop'),
    (6, 'Justice League', 2017, 'Zack Snyder', 'DCEU', 'Flop'),
    (7, 'Superman (2025)', 2025, 'James Gunn', 'DCU', 'TBD');

INSERT INTO Actors  VALUES
    (1, 'Christopher Reeve', 1978, 'Film'),
    (2, 'Brandon Routh',     2006, 'Film'),
    (3, 'Henry Cavill',      2013, 'Film'),
    (4, 'George Reeves',     1951, 'TV'),
    (5, 'Tom Welling',       2001, 'TV'),
    (6, 'Tyler Hoechlin',    2016, 'TV'),
    (7, 'Dean Cain',         1993, 'TV'),
    (8, 'David Corenswet',   2025, 'Film');

INSERT INTO ActorMovies VALUES
    (1, 1, 'Superman'),
    (1, 2, 'Superman'),
    (2, 3, 'Superman'),
    (3, 4, 'Superman'),
    (3, 5, 'Superman'),
    (3, 6, 'Superman'),
    (4, 7, 'Superman');

-- Christopher Reeve projects
INSERT INTO Projects (ProjectID, Title, ReleaseYear, Medium) VALUES 
    (1, 'Superman (1978)', 1978, 'Film'),
    (2, 'Gray Lady Down', 1978, 'Film'),
    (3, 'Somewhere in Time', 1980, 'Film'),
    (4, 'Superman II', 1980, 'Film'),
    (5, 'Deathtrap', 1982, 'Film'),
    (6, 'Monsignor', 1982, 'Film'),
    (7, 'Superman III', 1983, 'Film'),
    (8, 'The Bostonians', 1984, 'Film'),
    (9, 'The Aviator', 1985, 'Film'),
    (10, 'Street Smart', 1987, 'Film'),
    (11, 'Superman IV: The Quest for Peace', 1987, 'Film'),
    (12, 'Switching Channels', 1988, 'Film'),
    (13, 'Morning Glory', 1993, 'Film'),
    (14, 'The Remains of the Day', 1993, 'Film'),
    (15, 'Speechless', 1994, 'Film'),
    (16, 'Village of the Damned', 1995, 'Film'),
    (17, 'Everyone’s Hero', 2006, 'Film'), -- Posthumous voice role

    (18, 'The Muppets Go Hollywood', 1979, 'TV'),
    (19, 'Anna Karenina', 1985, 'TV'),
    (20, 'The Great Escape II: The Untold Story', 1988, 'TV'),
    (21, 'The Rose and the Jackal', 1990, 'TV'),
    (22, 'Death Dreams', 1991, 'TV'),
    (23, 'Nightmare in the Daylight', 1992, 'TV'),
    (24, 'Mortal Sins', 1992, 'TV'),
    (25, 'Black Fox', 1995, 'TV'),
    (26, 'Rear Window', 1998, 'TV'),
    (27, 'The Practice', 2000, 'TV'),
    (28, 'Smallville', 2003, 'TV');

-- Brandon Routh projects 
INSERT INTO Projects (ProjectID, Title, ReleaseYear, Medium) VALUES 
    (29, 'Superman Returns', 2006, 'Film' ), 
    (30, 'Scott Pilgrim VS. The World', 2010, 'Film'), 
    (31, 'Zack and Miri ', 2008, 'Film'), 
    (32, 'Life is Hot in Cracktown', 2009, 'Film'), 
    (33, 'Crooked Arrows', 2012, 'Film'), 
    (34, '400 Days', 2016, 'Film'), 
    (35, 'Dylan Dog: Dead Of Night', 2011, 'Film'), 
    (36, 'Table For Three', 2009, 'Film'), 
    (37, 'Unthinkable', 2010, 'Film'), 
    (38, 'Kambakkht Ishq', 2009, 'Film'), 
    (39, 'Stuntmen', 2009, 'Film'), 
    (40, 'Miss Nobody', 2010, 'Film'), 
    (41, 'Missing William', 2014, 'Film'), 
    (42, 'The Nine Lives Of Christmas', 2014, 'Film'), 
    (43, 'The Nine Kittens Of Christmas', 2021, 'Film'), 
    (44, 'Denial', 2010, 'Film'), 
    (45, 'Karla', 2006, 'Film'),
    (46, 'Odd Man Out', 1999, 'TV'), 
    (47, 'Undressed', 2000, 'TV'),
    (48, 'Gilmore Girls', 2001, 'TV'), 
    (49, 'One Life To Live', 2001-2002, 'TV'), 
    (50, 'Will and Grace', 2004, 'TV'), 
    (51, 'Cold Case', 2003, 'TV'), 
    (52, 'Chuck', 2010-2011, 'TV'), 
    (53, 'Partners', 2012, 'TV'), 
    (54, 'The Millers', 2014, 'TV'), 
    (55, 'Enlisted', 2014, 'TV'), 
    (56, 'Chosen', 2013-2014, 'TV'), 
    (57, 'The Exes', 2014, 'TV'), 
    (58, 'Fear Itself', 2008, 'TV'), 
    (59, 'Black-ish', 2019, 'TV'),
    (60, 'Lady Dynamite', 2016, 'TV'), 
    (61, 'Arrow', 2014-2020, 'TV'), 
    (62, 'The Flash', 2015-2022, 'TV'), 
    (63, 'Supergirl', 2019, 'TV'), 
    (64, 'Batwoman', 2019, 'TV'), 
    (65, 'DC Legends Of Tomorrow', 2016-2021, 'TV'), 
    (66, 'Vixen', 2015-2016, 'TV'), 
    (67, 'Quantum Leap', 2023, 'TV'), 
    (68, 'With Love', 2021, 'TV'), 
    (69, 'The Rookie', 2021, 'TV'), 
    (70, 'Scott Pilgrim Takes Off', 2023, 'TV'), 
    (71, 'Are You Afraid Of The Dark?', 2019, 'TV');

-- Henry Cavill projects 
INSERT INTO Projects (ProjectID, Title, ReleaseYear, Medium) VALUES 
    (72, 'The Count of Monte Cristo', 2002, 'Film'),
    (73, 'Goodbye, Mr. Chips', 2002, 'TV'), 
    (74, 'The Inspector Lynley Mysteries', 2002, 'TV'), 
    (75, 'I Capture the Castle', 2003, 'Film'), 
    (76, 'Midsomer Murders', 2003, 'TV'), 
    (77, 'Hellraiser: Hellworld', 2005, 'Film'), 
    (78, 'Red Riding Hood', 2006, 'Film'), 
    (79, 'Tristan & Isolde', 2006, 'Film'), 
    (80, 'Stardust', 2007, 'Film'), 
    (81, 'Whatever Works', 2009, 'Film'), 
    (82, 'Blood Creek', 2009, 'Film'), 
    (83, 'The Tudors', 2007, 'TV'), 
    (84, 'Immortals', 2011, 'Film'), 
    (85, 'The Cold Light of Day', 2012, 'Film'), 
    (86, 'Man of Steel', 2013, 'Film'), 
    (87, 'The Man From U.N.C.L.E.', 2015, 'Film'), 
    (88, 'Batman v Superman: Dawn of Justice', 2016, 'Film'), 
    (89, 'Sand Castle', 2017, 'Film'), 
    (90, 'Justice League', 2017, 'Film'), 
    (91, 'Mission: Impossible - Fallout', 2018, 'Film'), 
    (92, 'Night Hunter', 2018, 'Film'), 
    (93, 'Enola Holmes', 2020, 'Film'), 
    (94, 'Zack Snyders Justice League', 2021, 'Film'), 
    (95, 'Enola Holmes 2', 2022, 'Film'), 
    (96, 'The Witcher', 2019, 'TV'), 
    (97, 'Argylle', 2024, 'Film'), 
    (98, 'The Ministry of Ungentlemanly Warfare', 2024, 'Film'), 
    (99, 'Black Adam', 2022, 'Film'), 
    (100, 'Deadpool & Wolverine', 2024, 'Film'), 
    (101, 'In the Grey', 2025, 'Film');

-- George Reeves Projects 
INSERT INTO Projects (ProjectID, Title, ReleaseYear, Medium) VALUES 
    (102, 'Gone with the Wind', 1939, 'Film'),
    (103, 'Espionage Agent', 1939, 'Film'),
    (104, 'On Dress Parade', 1939, 'Film'),
    (105, 'Four Wives', 1939, 'Film'),
    (106, 'Calling Philo Vance', 1939, 'Film'),
    (107, 'The Fighting 69th', 1940, 'Film'),
    (108, 'Virginia City', 1940, 'Film'),
    (109, '’Til We Meet Again', 1940, 'Film'),
    (110, 'Tear Gas Squad', 1940, 'Film'),
    (111, 'Torrid Zone', 1940, 'Film'),
    (112, 'Gambling on the High Seas', 1940, 'Film'),
    (113, 'Ladies Must Live', 1940, 'Film'),
    (114, 'Argentine Nights', 1940, 'Film'),
    (115, 'Calling All Husbands', 1940, 'Film'),
    (116, 'Knute Rockne All American', 1940, 'Film'),
    (117, 'Always a Bride', 1940, 'Film'),
    (118, 'Father Is a Prince', 1940, 'Film'),
    (119, 'The Strawberry Blonde', 1941, 'Film'),
    (120, 'Dead Men Tell', 1941, 'Film'),
    (121, 'Blood and Sand', 1941, 'Film'),
    (122, 'Lydia', 1941, 'Film'),
    (123, 'Man at Large', 1941, 'Film'),
    (124, 'Blue, White and Perfect', 1942, 'Film'),
    (125, 'The Mad Martindales', 1942, 'Film'),
    (126, 'Hoppy Serves a Writ', 1943, 'Film'),
    (127, 'Border Patrol', 1943, 'Film'),
    (128, 'Buckskin Frontier', 1943, 'Film'),
    (129, 'The Leather Burners', 1943, 'Film'),
    (130, 'Colt Comrades', 1943, 'Film'),
    (131, 'So Proudly We Hail!', 1943, 'Film'),
    (132, 'Bar 20', 1943, 'Film'),
    (133, 'Winged Victory', 1944, 'Film'),
    (134, 'Variety Girl', 1947, 'Film'),
    (135, 'The Sainted Sisters', 1948, 'Film'),
    (136, 'Jungle Goddess', 1948, 'Film'),
    (137, 'Thunder in the Pines', 1948, 'Film'),
    (138, 'Jungle Jim', 1948, 'Film'),
    (139, 'The Mutineers', 1949, 'Film'),
    (140, 'Special Agent', 1949, 'Film'),
    (141, 'The Clock', 1949, 'Film'),
    (142, 'The Great Lover', 1949, 'Film'),
    (143, 'Samson and Delilah', 1949, 'Film'),
    (144, 'The Adventures of Sir Galahad', 1949, 'TV'),
    (145, 'The Good Humor Man', 1950, 'Film'),
    (146, 'The Trap', 1950, 'Film'),
    (147, 'Starlight Theatre', 1950, 'TV'),
    (148, 'Hands of Murder', 1950, 'TV'),
    (149, 'Suspense', 1950, 'TV'),
    (150, 'Lights Out', 1951, 'TV'),
    (151, 'Superman and the Mole Men', 1951, 'Film'),
    (152, 'Bugles in the Afternoon', 1952, 'Film'),
    (153, 'Rancho Notorious', 1952, 'Film'),
    (154, 'The Blue Gardenia', 1953, 'Film'),
    (155, 'From Here to Eternity', 1953, 'Film'),
    (156, 'Forever Female', 1953, 'Film'),
    (157, 'Westward Ho the Wagons!', 1956, 'Film'),
    (158, 'I Love Lucy', 1957, 'TV'),
    (159, 'The Adventures of Superman', 1958, 'TV');

-- Tom Welling Projects 
INSERT INTO Projects (ProjectID, Title, ReleaseYear, Medium) VALUES 
    (160, 'Judging Amy', 2002, 'TV'),
    (161, 'Special Unit 2', 2001, 'TV'),
    (162, 'Undeclared', 2001, 'TV'),
    (163, 'Smallville', 2011, 'TV'),
    (164, 'Cheaper by the Dozen', 2003, 'Film'),
    (165, 'The Fog', 2005, 'Film'),
    (166, 'Cheaper by the Dozen 2', 2005, 'Film'),
    (167, 'Parkland', 2013, 'Film'),
    (168, 'Draft Day', 2014, 'Film'),
    (169, 'The Choice', 2016, 'Film'),
    (170, 'Lucifer', 2018, 'TV'),
    (171, 'Batwoman', 2019, 'TV'),
    (172, 'Professionals', 2020, 'TV'),
    (173, 'The Winchesters', 2022, 'TV'),
    (174, 'TalkVille', 2022, 'TV');

-- Tyler Hoechlin Projects 
INSERT INTO Projects (ProjectID, Title, ReleaseYear, Medium) Values 
    (175, 'Disney Sing-Along Songs: Happy Haunting', 1998, 'Film'),
    (176, 'Family Tree', 1999, 'Film'),
    (177, 'Train Quest', 2001, 'Film'),
    (178, 'Road to Perdition', 2002, 'Film'),
    (179, '7th Heaven', 2007, 'TV'),
    (180, 'CSI: Miami', 2007, 'TV'),
    (181, 'Grizzly Rage', 2007, 'TV'),
    (182, 'Solstice', 2008, 'Film'),
    (183, 'Castle', 2009, 'TV'),
    (184, 'Lincoln Heights', 2009, 'TV'),
    (185, 'My Boys', 2009, 'TV'),
    (186, 'Hall Pass', 2011, 'Film'),
    (187, 'Open Gate', 2011, 'Film'),
    (188, 'Melvin Smarty', 2012, 'Film'),
    (189, 'Teen Wolf', 2017, 'TV'),
    (190, 'Everybody Wants Some!!', 2016, 'Film'),
    (191, 'Undrafted', 2016, 'Film'),
    (192, 'Stratton', 2017, 'Film'),
    (193, 'Bigger', 2018, 'Film'),
    (194, 'The Domestics', 2018, 'Film'),
    (195, 'Fifty Shades Freed', 2018, 'Film'),
    (196, 'Then Came You', 2019, 'Film'),
    (197, 'Can You Keep a Secret?', 2019, 'Film'),
    (198, 'Palm Springs', 2020, 'Film'),
    (199, 'Supergirl', 2019, 'TV'),
    (200, 'The Flash', 2019, 'TV'),
    (201, 'Arrow', 2020, 'TV'),
    (202, 'Batwoman', 2019, 'TV'),
    (203, 'DCs Legends of Tomorrow', 2020, 'TV'),
    (204, 'Another Life', 2019, 'TV'),
    (205, 'Superman & Lois', 2024, 'TV'),
    (206, 'Teen Wolf: The Movie', 2023, 'Film');


-- Dean Cain Projects 
INSERT INTO Projects(ProjectID, Title, ReleaseYear, Medium) VALUES 
    (207, 'Lois & Clark: The New Adventures of Superman', 1997, 'TV'),
    (208, 'Beverly Hills, 90210', 1992, 'TV'),
    (209, 'Grapevine', 1992, 'TV'),
    (210, 'A Different World', 1992, 'TV'),
    (211, 'Miracle Beach', 1992, 'Film'),
    (212, 'The Broken Hearts Club: A Romantic Comedy', 2000, 'Film'),
    (213, 'Out of Time', 2003, 'Film'),
    (214, 'Bailey’s Billion$', 2004, 'Film'),
    (215, 'The Perfect Husband: The Laci Peterson Story', 2004, 'TV'),
    (216, 'Las Vegas', 2006, 'TV'),
    (217, 'Supergirl', 2017, 'TV'),
    (218, 'Hit the Floor', 2016, 'TV'),
    (219, 'God’s Not Dead', 2014, 'Film'),
    (220, 'Lady Dynamite', 2016, 'TV'),
    (221, 'Vendetta', 2015, 'Film'),
    (222, 'Broadcasting Christmas', 2016, 'Film'),
    (223, 'The Dog Who Saved Christmas', 2009, 'Film'),
    (224, 'The Dog Who Saved Easter', 2014, 'Film'),
    (225, 'The Dog Who Saved Summer', 2015, 'Film'),
    (226, 'The Dog Who Saved the Holidays', 2012, 'Film'),
    (227, 'Gosnell: The Trial of America’s Biggest Serial Killer', 2018, 'Film'),
    (228, 'Andy the Talking Hedgehog', 2018, 'Film'),
    (229, 'Madness in the Method', 2019, 'Film'),
    (230, 'A Parent’s Worst Nightmare', 2017, 'Film'),
    (231, 'The Incantation', 2018, 'Film'),
    (232, 'Illicit', 2017, 'Film'),
    (233, 'The Three Dogateers', 2014, 'Film'),
    (234, 'A Belle for Christmas', 2014, 'Film'),
    (235, 'Holiday Miracle', 2014, 'Film'),
    (236, 'Horse Camp', 2014, 'Film'),
    (237, 'A Wish Come True', 2015, 'Film'),
    (238, 'A Horse for Summer', 2015, 'Film'),
    (239, 'Merry Ex-Mas', 2014, 'Film'),
    (240, 'Airplane vs. Volcano', 2014, 'Film'),
    (241, 'The Appearing', 2014, 'Film'),
    (242, 'Defending Santa', 2013, 'Film'),
    (243, 'Operation Cupcake', 2012, 'Film'),
    (244, 'I Am Gabriel', 2012, 'Film'),
    (245, 'Meant to Be', 2012, 'Film'),
    (246, 'Home Run Showdown', 2012, 'Film'),
    (247, 'Criminal Minds', 2011, 'TV'),
    (248, 'Burn Notice', 2011, 'TV'),
    (249, 'The Case for Christmas', 2011, 'Film'),
    (250, 'Dirty Little Trick', 2011, 'Film'),
    (251, 'A Mile in His Shoes', 2011, 'Film'),
    (252, '5 Days of War', 2011, 'Film'),
    (253, 'Bed & Breakfast', 2010, 'Film'),
    (254, 'A Nanny for Christmas', 2010, 'Film'),
    (255, 'Kill Katie Malone', 2010, 'Film'),
    (256, 'Abandoned', 2010, 'Film'),
    (257, 'Frost Giant', 2010, 'Film'),
    (258, 'The Way Home', 2010, 'Film');

-- David Corneswet projects 
INSERT INTO Projects(ProjectID, Title, ReleaseYear, Medium) VALUES 
    (259, 'Following Chase', 2011, 'Film'),
    (260, 'Michael and Clyde', 2013, 'Film'),
    (261, 'House of Cards', 2018, 'TV'),
    (262, 'Affairs of State', 2018, 'Film'),
    (263, 'The Tap', 2017, 'Film'),
    (264, 'The Politician', '2020', 'TV'),
    (265, 'Hollywood', 2020, 'TV'),
    (266, 'Look Both Ways', 2022, 'Film'),
    (267, 'Pearl', 2022, 'Film'),
    (268, 'The Projectionist', 2022, 'Film'),
    (269, 'We Own This City', 2022, 'TV'),
    (270, 'The Greatest Hits', 2024, 'Film'),
    (271, 'Twisters', 2024, 'Film'),
    (272, 'Superman', 2025, 'Film');

-- 1 Christopher Reeve projects (IDs 1–28)
INSERT INTO ActorProjects VALUES 
    (1, 1), (1, 2), (1, 3), (1, 4), (1, 5), (1, 6), (1, 7), (1, 8), (1, 9), (1, 10),
    (1, 11), (1, 12), (1, 13), (1, 14), (1, 15), (1, 16), (1, 17), (1, 18), (1, 19),
    (1, 20), (1, 21), (1, 22), (1, 23), (1, 24), (1, 25), (1, 26), (1, 27), (1, 28);

-- 2 Brandon Routh projects (IDs 29–71)
INSERT INTO ActorProjects VALUES
    (2, 29), (2, 30), (2, 31), (2, 32), (2, 33), (2, 34), (2, 35), (2, 36), (2, 37), (2, 38),
    (2, 39), (2, 40), (2, 41), (2, 42), (2, 43), (2, 44), (2, 45), (2, 46), (2, 47), (2, 48),
    (2, 49), (2, 50), (2, 51), (2, 52), (2, 53), (2, 54), (2, 55), (2, 56), (2, 57), (2, 58),
    (2, 59), (2, 60), (2, 61), (2, 62), (2, 63), (2, 64), (2, 65), (2, 66), (2, 67), (2, 68),
    (2, 69), (2, 70), (2, 71);

-- 3 Henry Cavill projects (IDs 72–100)
INSERT INTO ActorProjects VALUES
    (3, 72), (3, 73), (3, 74), (3, 75), (3, 76), (3, 77), (3, 78), (3, 79), (3, 80), (3, 81),
    (3, 82), (3, 83), (3, 84), (3, 85), (3, 86), (3, 87), (3, 88), (3, 89), (3, 90), (3, 91),
    (3, 92), (3, 93), (3, 94), (3, 95), (3, 96), (3, 97), (3, 98), (3, 99), (3, 100);

-- 4 George Reeves projects (IDs 102–159)
INSERT INTO ActorProjects VALUES
    (4, 102), (4, 103), (4, 104), (4, 105), (4, 106), (4, 107), (4, 108), (4, 109), (4, 110), (4, 111),
    (4, 112), (4, 113), (4, 114), (4, 115), (4, 116), (4, 117), (4, 118), (4, 119), (4, 120), (4, 121),
    (4, 122), (4, 123), (4, 124), (4, 125), (4, 126), (4, 127), (4, 128), (4, 129), (4, 130), (4, 131),
    (4, 132), (4, 133), (4, 134), (4, 135), (4, 136), (4, 137), (4, 138), (4, 139), (4, 140), (4, 141),
    (4, 142), (4, 143), (4, 144), (4, 145), (4, 146), (4, 147), (4, 148), (4, 149), (4, 150), (4, 151),
    (4, 152), (4, 153), (4, 154), (4, 155), (4, 156), (4, 157), (4, 158), (4, 159);

-- 5 Tom Welling projects (IDs 160–174)
INSERT INTO ActorProjects VALUES
    (5, 160), (5, 161), (5, 162), (5, 163), (5, 164), (5, 165), (5, 166), (5, 167), (5, 168), (5, 169),
    (5, 170), (5, 171), (5, 172), (5, 173), (5, 174);

-- 6 Tyler Hoechlin projects (IDs 175–206)
INSERT INTO ActorProjects VALUES
    (6, 175), (6, 176), (6, 177), (6, 178), (6, 179), (6, 180), (6, 181), (6, 182), (6, 183), (6, 184),
    (6, 185), (6, 186), (6, 187), (6, 188), (6, 189), (6, 190), (6, 191), (6, 192), (6, 193), (6, 194),
    (6, 195), (6, 196), (6, 197), (6, 198), (6, 199), (6, 200), (6, 201), (6, 202), (6, 203), (6, 204),
    (6, 205), (6, 206);

-- 7 Dean Cain projects (IDs 207–258)
INSERT INTO ActorProjects VALUES
    (7, 207), (7, 208), (7, 209), (7, 210), (7, 211), (7, 212), (7, 213), (7, 214), (7, 215), (7, 216),
    (7, 217), (7, 218), (7, 219), (7, 220), (7, 221), (7, 222), (7, 223), (7, 224), (7, 225), (7, 226),
    (7, 227), (7, 228), (7, 229), (7, 230), (7, 231), (7, 232), (7, 233), (7, 234), (7, 235), (7, 236),
    (7, 237), (7, 238), (7, 239), (7, 240), (7, 241), (7, 242), (7, 243), (7, 244), (7, 245), (7, 246),
    (7, 247), (7, 248), (7, 249), (7, 250), (7, 251), (7, 252), (7, 253), (7, 254), (7, 255), (7, 256),
    (7, 257), (7, 258);

-- 8 David Corenswet projects (IDs 259–272)
INSERT INTO ActorProjects VALUES
    (8, 259), (8, 260), (8, 261), (8, 262), (8, 263), (8, 264), (8, 265), (8, 266), (8, 267), (8, 268),
    (8, 269), (8, 270), (8, 271), (8, 272);

SELECT*
FROM Actors
ORDER BY FirstAppearanceYear ASC;

SELECT ap.*, p.Title, p.ReleaseYear, p.Medium
FROM ActorProjects ap
JOIN Actors a ON ap.ActorID = a.ActorID
JOIN Projects p ON ap.ProjectID = p.ProjectID
WHERE a.Name = 'David Corenswet';

SELECT ap.*, p.Title, p.ReleaseYear, p.Medium
FROM ActorProjects ap
JOIN Actors a ON ap.ActorID = a.ActorID
JOIN Projects p ON ap.ProjectID = p.ProjectID
WHERE a.Name = 'Tyler Hoechlin';