CREATE TABLE Actors (
    ActorID INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    ActorName VARCHAR(30),
    CharacterName VARCHAR(30),
    BirthDate SMALLINT NOT NULL,
    Nationality VARCHAR(30)
);

CREATE TABLE Directors (
    DirectorID INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    DirectorName VARCHAR(30) NOT NULL,
    BirthDate DATE,
    Nationality VARCHAR(50)
);

CREATE TABLE Episodes (
    EpisodeID INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    Title VARCHAR(100) NOT NULL,
    SeasonNumber SMALLINT NOT NULL,
    EpisodeNumber SMALLINT NOT NULL,
    AirDate DATE NOT NULL,
    DirectorID INT UNSIGNED,
    FOREIGN KEY (DirectorID) REFERENCES Directors(DirectorID)
);

CREATE TABLE EpisodeViews (
    ViewID INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    EpisodeID INT UNSIGNED,
    ViewDate DATE NOT NULL,
    ViewCount INT UNSIGNED NOT NULL,
    FOREIGN KEY (EpisodeID) REFERENCES Episodes(EpisodeID)
);

CREATE TABLE EpisodeActors (
    EpisodeID INT UNSIGNED,
    ActorID INT UNSIGNED,
    RoleType VARCHAR(50),
    PRIMARY KEY (EpisodeID, ActorID),
    FOREIGN KEY (EpisodeID) REFERENCES Episodes(EpisodeID),
    FOREIGN KEY (ActorID) REFERENCES Actors(ActorID)
);


INSERT INTO Actors(ActorID, ActorName, CharacterName, BirthDate, Nationality) VALUES
(1, 'Tom Welling', 'Clark Kent', 1977, 'USA'),(2, 'Kristin Kreuk', 'Lana Lang', 1982, 'Canada'),(3, 'Michael Rosenbaum', 'Lex Luthor', 1972, 'USA'),(4, 'Allison Mack', 'Chloe Sullivan', 1982, 'Germany'),(5, 'Erica Durance', 'Lois Lane', 1978, 'Canada');

INSERT INTO Directors(DirectorID, DirectorName, BirthDate, Nationality) VALUES
(1, 'Greg Beeman', '1962-01-01', 'USA'),(2, 'James Marshall', '1952-01-01', 'USA'),(3, 'Michael Rohl', '1960-01-01', 'Canada'),(4, 'Jeannot Szwarc', '1939-11-21', 'France'),(5, 'Rick Rosenthal', '1949-06-15', 'USA');

INSERT INTO Episodes(EpisodeID, Title, SeasonNumber, EpisodeNumber, AirDate, DirectorID) VALUES
(1, 'Episode 1', 1, 1, '2001-10-16', 2),(2, 'Episode 2', 1, 2, '2001-10-23', 3),(3, 'Episode 3', 1, 3, '2001-10-30', 4),(4, 'Episode 4', 1, 4, '2001-11-06', 5),(5, 'Episode 5', 1, 5, '2001-11-13', 1),(6, 'Episode 6', 1, 6, '2001-11-20', 2),(7, 'Episode 7', 1, 7, '2001-11-27', 3),(8, 'Episode 8', 1, 8, '2001-12-04', 4),(9, 'Episode 9', 1, 9, '2001-12-11', 5),(10, 'Episode 10', 1, 10, '2001-12-18', 1),(11, 'Episode 11', 1, 11, '2001-12-25', 2),(12, 'Episode 12', 1, 12, '2002-01-01', 3),(13, 'Episode 13', 1, 13, '2002-01-08', 4),(14, 'Episode 14', 1, 14, '2002-01-15', 5),(15, 'Episode 15', 1, 15, '2002-01-22', 1),(16, 'Episode 16', 1, 16, '2002-01-29', 2),(17, 'Episode 17', 1, 17, '2002-02-05', 3),(18, 'Episode 18', 1, 18, '2002-02-12', 4),(19, 'Episode 19', 1, 19, '2002-02-19', 5),(20, 'Episode 20', 1, 20, '2002-02-26', 1),(21, 'Episode 21', 1, 21, '2002-03-05', 2),(22, 'Episode 22', 2, 1, '2002-03-12', 3),(23, 'Episode 23', 2, 2, '2002-03-19', 4),(24, 'Episode 24', 2, 3, '2002-03-26', 5),(25, 'Episode 25', 2, 4, '2002-04-02', 1),(26, 'Episode 26', 2, 5, '2002-04-09', 2),(27, 'Episode 27', 2, 6, '2002-04-16', 3),(28, 'Episode 28', 2, 7, '2002-04-23', 4),(29, 'Episode 29', 2, 8, '2002-04-30', 5),(30, 'Episode 30', 2, 9, '2002-05-07', 1),(31, 'Episode 31', 2, 10, '2002-05-14', 2),(32, 'Episode 32', 2, 11, '2002-05-21', 3),(33, 'Episode 33', 2, 12, '2002-05-28', 4),(34, 'Episode 34', 2, 13, '2002-06-04', 5),(35, 'Episode 35', 2, 14, '2002-06-11', 1),(36, 'Episode 36', 2, 15, '2002-06-18', 2),(37, 'Episode 37', 2, 16, '2002-06-25', 3),(38, 'Episode 38', 2, 17, '2002-07-02', 4),(39, 'Episode 39', 2, 18, '2002-07-09', 5),(40, 'Episode 40', 2, 19, '2002-07-16', 1),(41, 'Episode 41', 2, 20, '2002-07-23', 2),(42, 'Episode 42', 2, 21, '2002-07-30', 3),(43, 'Episode 43', 2, 22, '2002-08-06', 4),(44, 'Episode 44', 2, 23, '2002-08-13', 5),(45, 'Episode 45', 3, 1, '2002-08-20', 1),(46, 'Episode 46', 3, 2, '2002-08-27', 2),(47, 'Episode 47', 3, 3, '2002-09-03', 3),(48, 'Episode 48', 3, 4, '2002-09-10', 4),(49, 'Episode 49', 3, 5, '2002-09-17', 5),(50, 'Episode 50', 3, 6, '2002-09-24', 1),(51, 'Episode 51', 3, 7, '2002-10-01', 2),(52, 'Episode 52', 3, 8, '2002-10-08', 3),(53, 'Episode 53', 3, 9, '2002-10-15', 4),(54, 'Episode 54', 3, 10, '2002-10-22', 5),(55, 'Episode 55', 3, 11, '2002-10-29', 1),(56, 'Episode 56', 3, 12, '2002-11-05', 2),(57, 'Episode 57', 3, 13, '2002-11-12', 3),(58, 'Episode 58', 3, 14, '2002-11-19', 4),(59, 'Episode 59', 3, 15, '2002-11-26', 5),(60, 'Episode 60', 3, 16, '2002-12-03', 1),(61, 'Episode 61', 3, 17, '2002-12-10', 2),(62, 'Episode 62', 3, 18, '2002-12-17', 3),(63, 'Episode 63', 3, 19, '2002-12-24', 4),(64, 'Episode 64', 3, 20, '2002-12-31', 5),(65, 'Episode 65', 3, 21, '2003-01-07', 1),(66, 'Episode 66', 3, 22, '2003-01-14', 2),(67, 'Episode 67', 4, 1, '2003-01-21', 3),(68, 'Episode 68', 4, 2, '2003-01-28', 4),(69, 'Episode 69', 4, 3, '2003-02-04', 5),(70, 'Episode 70', 4, 4, '2003-02-11', 1),(71, 'Episode 71', 4, 5, '2003-02-18', 2),(72, 'Episode 72', 4, 6, '2003-02-25', 3),(73, 'Episode 73', 4, 7, '2003-03-04', 4),(74, 'Episode 74', 4, 8, '2003-03-11', 5),(75, 'Episode 75', 4, 9, '2003-03-18', 1),(76, 'Episode 76', 4, 10, '2003-03-25', 2),(77, 'Episode 77', 4, 11, '2003-04-01', 3),(78, 'Episode 78', 4, 12, '2003-04-08', 4),(79, 'Episode 79', 4, 13, '2003-04-15', 5),(80, 'Episode 80', 4, 14, '2003-04-22', 1),(81, 'Episode 81', 4, 15, '2003-04-29', 2),(82, 'Episode 82', 4, 16, '2003-05-06', 3),(83, 'Episode 83', 4, 17, '2003-05-13', 4),(84, 'Episode 84', 4, 18, '2003-05-20', 5),(85, 'Episode 85', 4, 19, '2003-05-27', 1),(86, 'Episode 86', 4, 20, '2003-06-03', 2),(87, 'Episode 87', 4, 21, '2003-06-10', 3),(88, 'Episode 88', 4, 22, '2003-06-17', 4),(89, 'Episode 89', 5, 1, '2003-06-24', 5),(90, 'Episode 90', 5, 2, '2003-07-01', 1),(91, 'Episode 91', 5, 3, '2003-07-08', 2),(92, 'Episode 92', 5, 4, '2003-07-15', 3),(93, 'Episode 93', 5, 5, '2003-07-22', 4),(94, 'Episode 94', 5, 6, '2003-07-29', 5),(95, 'Episode 95', 5, 7, '2003-08-05', 1),(96, 'Episode 96', 5, 8, '2003-08-12', 2),(97, 'Episode 97', 5, 9, '2003-08-19', 3),(98, 'Episode 98', 5, 10, '2003-08-26', 4),(99, 'Episode 99', 5, 11, '2003-09-02', 5),(100, 'Episode 100', 5, 12, '2003-09-09', 1),(101, 'Episode 101', 5, 13, '2003-09-16', 2),(102, 'Episode 102', 5, 14, '2003-09-23', 3),(103, 'Episode 103', 5, 15, '2003-09-30', 4),(104, 'Episode 104', 5, 16, '2003-10-07', 5),(105, 'Episode 105', 5, 17, '2003-10-14', 1),(106, 'Episode 106', 5, 18, '2003-10-21', 2),(107, 'Episode 107', 5, 19, '2003-10-28', 3),(108, 'Episode 108', 5, 20, '2003-11-04', 4),(109, 'Episode 109', 5, 21, '2003-11-11', 5),(110, 'Episode 110', 5, 22, '2003-11-18', 1),(111, 'Episode 111', 6, 1, '2003-11-25', 2),(112, 'Episode 112', 6, 2, '2003-12-02', 3),(113, 'Episode 113', 6, 3, '2003-12-09', 4),(114, 'Episode 114', 6, 4, '2003-12-16', 5),(115, 'Episode 115', 6, 5, '2003-12-23', 1),(116, 'Episode 116', 6, 6, '2003-12-30', 2),(117, 'Episode 117', 6, 7, '2004-01-06', 3),(118, 'Episode 118', 6, 8, '2004-01-13', 4),(119, 'Episode 119', 6, 9, '2004-01-20', 5),(120, 'Episode 120', 6, 10, '2004-01-27', 1),(121, 'Episode 121', 6, 11, '2004-02-03', 2),(122, 'Episode 122', 6, 12, '2004-02-10', 3),(123, 'Episode 123', 6, 13, '2004-02-17', 4),(124, 'Episode 124', 6, 14, '2004-02-24', 5),(125, 'Episode 125', 6, 15, '2004-03-02', 1),(126, 'Episode 126', 6, 16, '2004-03-09', 2),(127, 'Episode 127', 6, 17, '2004-03-16', 3),(128, 'Episode 128', 6, 18, '2004-03-23', 4),(129, 'Episode 129', 6, 19, '2004-03-30', 5),(130, 'Episode 130', 6, 20, '2004-04-06', 1),(131, 'Episode 131', 6, 21, '2004-04-13', 2),(132, 'Episode 132', 6, 22, '2004-04-20', 3),(133, 'Episode 133', 7, 1, '2004-04-27', 4),(134, 'Episode 134', 7, 2, '2004-05-04', 5),(135, 'Episode 135', 7, 3, '2004-05-11', 1),(136, 'Episode 136', 7, 4, '2004-05-18', 2),(137, 'Episode 137', 7, 5, '2004-05-25', 3),(138, 'Episode 138', 7, 6, '2004-06-01', 4),(139, 'Episode 139', 7, 7, '2004-06-08', 5),(140, 'Episode 140', 7, 8, '2004-06-15', 1),(141, 'Episode 141', 7, 9, '2004-06-22', 2),(142, 'Episode 142', 7, 10, '2004-06-29', 3),(143, 'Episode 143', 7, 11, '2004-07-06', 4),(144, 'Episode 144', 7, 12, '2004-07-13', 5),(145, 'Episode 145', 7, 13, '2004-07-20', 1),(146, 'Episode 146', 7, 14, '2004-07-27', 2),(147, 'Episode 147', 7, 15, '2004-08-03', 3),(148, 'Episode 148', 7, 16, '2004-08-10', 4),(149, 'Episode 149', 7, 17, '2004-08-17', 5),(150, 'Episode 150', 7, 18, '2004-08-24', 1),(151, 'Episode 151', 7, 19, '2004-08-31', 2),(152, 'Episode 152', 7, 20, '2004-09-07', 3),(153, 'Episode 153', 8, 1, '2004-09-14', 4),(154, 'Episode 154', 8, 2, '2004-09-21', 5),(155, 'Episode 155', 8, 3, '2004-09-28', 1),(156, 'Episode 156', 8, 4, '2004-10-05', 2),(157, 'Episode 157', 8, 5, '2004-10-12', 3),(158, 'Episode 158', 8, 6, '2004-10-19', 4),(159, 'Episode 159', 8, 7, '2004-10-26', 5),(160, 'Episode 160', 8, 8, '2004-11-02', 1),(161, 'Episode 161', 8, 9, '2004-11-09', 2),(162, 'Episode 162', 8, 10, '2004-11-16', 3),(163, 'Episode 163', 8, 11, '2004-11-23', 4),(164, 'Episode 164', 8, 12, '2004-11-30', 5),(165, 'Episode 165', 8, 13, '2004-12-07', 1),(166, 'Episode 166', 8, 14, '2004-12-14', 2),(167, 'Episode 167', 8, 15, '2004-12-21', 3),(168, 'Episode 168', 8, 16, '2004-12-28', 4),(169, 'Episode 169', 8, 17, '2005-01-04', 5),(170, 'Episode 170', 8, 18, '2005-01-11', 1),(171, 'Episode 171', 8, 19, '2005-01-18', 2),(172, 'Episode 172', 8, 20, '2005-01-25', 3),(173, 'Episode 173', 8, 21, '2005-02-01', 4),(174, 'Episode 174', 8, 22, '2005-02-08', 5),(175, 'Episode 175', 9, 1, '2005-02-15', 1),(176, 'Episode 176', 9, 2, '2005-02-22', 2),(177, 'Episode 177', 9, 3, '2005-03-01', 3),(178, 'Episode 178', 9, 4, '2005-03-08', 4),(179, 'Episode 179', 9, 5, '2005-03-15', 5),(180, 'Episode 180', 9, 6, '2005-03-22', 1),(181, 'Episode 181', 9, 7, '2005-03-29', 2),(182, 'Episode 182', 9, 8, '2005-04-05', 3),(183, 'Episode 183', 9, 9, '2005-04-12', 4),(184, 'Episode 184', 9, 10, '2005-04-19', 5),(185, 'Episode 185', 9, 11, '2005-04-26', 1),(186, 'Episode 186', 9, 12, '2005-05-03', 2),(187, 'Episode 187', 9, 13, '2005-05-10', 3),(188, 'Episode 188', 9, 14, '2005-05-17', 4),(189, 'Episode 189', 9, 15, '2005-05-24', 5),(190, 'Episode 190', 9, 16, '2005-05-31', 1),(191, 'Episode 191', 9, 17, '2005-06-07', 2),(192, 'Episode 192', 9, 18, '2005-06-14', 3),(193, 'Episode 193', 9, 19, '2005-06-21', 4),(194, 'Episode 194', 9, 20, '2005-06-28', 5),(195, 'Episode 195', 9, 21, '2005-07-05', 1),(196, 'Episode 196', 10, 1, '2005-07-12', 2),(197, 'Episode 197', 10, 2, '2005-07-19', 3),(198, 'Episode 198', 10, 3, '2005-07-26', 4),(199, 'Episode 199', 10, 4, '2005-08-02', 5),(200, 'Episode 200', 10, 5, '2005-08-09', 1),(201, 'Episode 201', 10, 6, '2005-08-16', 2),(202, 'Episode 202', 10, 7, '2005-08-23', 3),(203, 'Episode 203', 10, 8, '2005-08-30', 4),(204, 'Episode 204', 10, 9, '2005-09-06', 5),(205, 'Episode 205', 10, 10, '2005-09-13', 1),(206, 'Episode 206', 10, 11, '2005-09-20', 2),(207, 'Episode 207', 10, 12, '2005-09-27', 3),(208, 'Episode 208', 10, 13, '2005-10-04', 4),(209, 'Episode 209', 10, 14, '2005-10-11', 5),(210, 'Episode 210', 10, 15, '2005-10-18', 1),(211, 'Episode 211', 10, 16, '2005-10-25', 2),(212, 'Episode 212', 10, 17, '2005-11-01', 3),(213, 'Episode 213', 10, 18, '2005-11-08', 4),(214, 'Episode 214', 10, 19, '2005-11-15', 5),(215, 'Episode 215', 10, 20, '2005-11-22', 1),(216, 'Episode 216', 10, 21, '2005-11-29', 2),(217, 'Episode 217', 10, 22, '2005-12-06', 3);

INSERT INTO EpisodeViews(ViewID, EpisodeID, ViewDate, ViewCount) VALUES
(1, 1, '2001-10-16', 7000001),(2, 2, '2001-10-23', 7000002),(3, 3, '2001-10-30', 7000003),(4, 4, '2001-11-06', 7000004),(5, 5, '2001-11-13', 7000005),(6, 6, '2001-11-20', 7000006),(7, 7, '2001-11-27', 7000007),(8, 8, '2001-12-04', 7000008),(9, 9, '2001-12-11', 7000009),(10, 10, '2001-12-18', 7000010),(11, 11, '2001-12-25', 7000011),(12, 12, '2002-01-01', 7000012),(13, 13, '2002-01-08', 7000013),(14, 14, '2002-01-15', 7000014),(15, 15, '2002-01-22', 7000015),(16, 16, '2002-01-29', 7000016),(17, 17, '2002-02-05', 7000017),(18, 18, '2002-02-12', 7000018),(19, 19, '2002-02-19', 7000019),(20, 20, '2002-02-26', 7000020),(21, 21, '2002-03-05', 7000021),(22, 22, '2002-03-12', 7000022),(23, 23, '2002-03-19', 7000023),(24, 24, '2002-03-26', 7000024),(25, 25, '2002-04-02', 7000025),(26, 26, '2002-04-09', 7000026),(27, 27, '2002-04-16', 7000027),(28, 28, '2002-04-23', 7000028),(29, 29, '2002-04-30', 7000029),(30, 30, '2002-05-07', 7000030),(31, 31, '2002-05-14', 7000031),(32, 32, '2002-05-21', 7000032),(33, 33, '2002-05-28', 7000033),(34, 34, '2002-06-04', 7000034),(35, 35, '2002-06-11', 7000035),(36, 36, '2002-06-18', 7000036),(37, 37, '2002-06-25', 7000037),(38, 38, '2002-07-02', 7000038),(39, 39, '2002-07-09', 7000039),(40, 40, '2002-07-16', 7000040),(41, 41, '2002-07-23', 7000041),(42, 42, '2002-07-30', 7000042),(43, 43, '2002-08-06', 7000043),(44, 44, '2002-08-13', 7000044),(45, 45, '2002-08-20', 7000045),(46, 46, '2002-08-27', 7000046),(47, 47, '2002-09-03', 7000047),(48, 48, '2002-09-10', 7000048),(49, 49, '2002-09-17', 7000049),(50, 50, '2002-09-24', 7000050),(51, 51, '2002-10-01', 7000051),(52, 52, '2002-10-08', 7000052),(53, 53, '2002-10-15', 7000053),(54, 54, '2002-10-22', 7000054),(55, 55, '2002-10-29', 7000055),(56, 56, '2002-11-05', 7000056),(57, 57, '2002-11-12', 7000057),(58, 58, '2002-11-19', 7000058),(59, 59, '2002-11-26', 7000059),(60, 60, '2002-12-03', 7000060),(61, 61, '2002-12-10', 7000061),(62, 62, '2002-12-17', 7000062),(63, 63, '2002-12-24', 7000063),(64, 64, '2002-12-31', 7000064),(65, 65, '2003-01-07', 7000065),(66, 66, '2003-01-14', 7000066),(67, 67, '2003-01-21', 7000067),(68, 68, '2003-01-28', 7000068),(69, 69, '2003-02-04', 7000069),(70, 70, '2003-02-11', 7000070),(71, 71, '2003-02-18', 7000071),(72, 72, '2003-02-25', 7000072),(73, 73, '2003-03-04', 7000073),(74, 74, '2003-03-11', 7000074),(75, 75, '2003-03-18', 7000075),(76, 76, '2003-03-25', 7000076),(77, 77, '2003-04-01', 7000077),(78, 78, '2003-04-08', 7000078),(79, 79, '2003-04-15', 7000079),(80, 80, '2003-04-22', 7000080),(81, 81, '2003-04-29', 7000081),(82, 82, '2003-05-06', 7000082),(83, 83, '2003-05-13', 7000083),(84, 84, '2003-05-20', 7000084),(85, 85, '2003-05-27', 7000085),(86, 86, '2003-06-03', 7000086),(87, 87, '2003-06-10', 7000087),(88, 88, '2003-06-17', 7000088),(89, 89, '2003-06-24', 7000089),(90, 90, '2003-07-01', 7000090),(91, 91, '2003-07-08', 7000091),(92, 92, '2003-07-15', 7000092),(93, 93, '2003-07-22', 7000093),(94, 94, '2003-07-29', 7000094),(95, 95, '2003-08-05', 7000095),(96, 96, '2003-08-12', 7000096),(97, 97, '2003-08-19', 7000097),(98, 98, '2003-08-26', 7000098),(99, 99, '2003-09-02', 7000099),(100, 100, '2003-09-09', 7000100),(101, 101, '2003-09-16', 7000101),(102, 102, '2003-09-23', 7000102),(103, 103, '2003-09-30', 7000103),(104, 104, '2003-10-07', 7000104),(105, 105, '2003-10-14', 7000105),(106, 106, '2003-10-21', 7000106),(107, 107, '2003-10-28', 7000107),(108, 108, '2003-11-04', 7000108),(109, 109, '2003-11-11', 7000109),(110, 110, '2003-11-18', 7000110),(111, 111, '2003-11-25', 7000111),(112, 112, '2003-12-02', 7000112),(113, 113, '2003-12-09', 7000113),(114, 114, '2003-12-16', 7000114),(115, 115, '2003-12-23', 7000115),(116, 116, '2003-12-30', 7000116),(117, 117, '2004-01-06', 7000117),(118, 118, '2004-01-13', 7000118),(119, 119, '2004-01-20', 7000119),(120, 120, '2004-01-27', 7000120),(121, 121, '2004-02-03', 7000121),(122, 122, '2004-02-10', 7000122),(123, 123, '2004-02-17', 7000123),(124, 124, '2004-02-24', 7000124),(125, 125, '2004-03-02', 7000125),(126, 126, '2004-03-09', 7000126),(127, 127, '2004-03-16', 7000127),(128, 128, '2004-03-23', 7000128),(129, 129, '2004-03-30', 7000129),(130, 130, '2004-04-06', 7000130),(131, 131, '2004-04-13', 7000131),(132, 132, '2004-04-20', 7000132),(133, 133, '2004-04-27', 7000133),(134, 134, '2004-05-04', 7000134),(135, 135, '2004-05-11', 7000135),(136, 136, '2004-05-18', 7000136),(137, 137, '2004-05-25', 7000137),(138, 138, '2004-06-01', 7000138),(139, 139, '2004-06-08', 7000139),(140, 140, '2004-06-15', 7000140),(141, 141, '2004-06-22', 7000141),(142, 142, '2004-06-29', 7000142),(143, 143, '2004-07-06', 7000143),(144, 144, '2004-07-13', 7000144),(145, 145, '2004-07-20', 7000145),(146, 146, '2004-07-27', 7000146),(147, 147, '2004-08-03', 7000147),(148, 148, '2004-08-10', 7000148),(149, 149, '2004-08-17', 7000149),(150, 150, '2004-08-24', 7000150),(151, 151, '2004-08-31', 7000151),(152, 152, '2004-09-07', 7000152),(153, 153, '2004-09-14', 7000153),(154, 154, '2004-09-21', 7000154),(155, 155, '2004-09-28', 7000155),(156, 156, '2004-10-05', 7000156),(157, 157, '2004-10-12', 7000157),(158, 158, '2004-10-19', 7000158),(159, 159, '2004-10-26', 7000159),(160, 160, '2004-11-02', 7000160),(161, 161, '2004-11-09', 7000161),(162, 162, '2004-11-16', 7000162),(163, 163, '2004-11-23', 7000163),(164, 164, '2004-11-30', 7000164),(165, 165, '2004-12-07', 7000165),(166, 166, '2004-12-14', 7000166),(167, 167, '2004-12-21', 7000167),(168, 168, '2004-12-28', 7000168),(169, 169, '2005-01-04', 7000169),(170, 170, '2005-01-11', 7000170),(171, 171, '2005-01-18', 7000171),(172, 172, '2005-01-25', 7000172),(173, 173, '2005-02-01', 7000173),(174, 174, '2005-02-08', 7000174),(175, 175, '2005-02-15', 7000175),(176, 176, '2005-02-22', 7000176),(177, 177, '2005-03-01', 7000177),(178, 178, '2005-03-08', 7000178),(179, 179, '2005-03-15', 7000179),(180, 180, '2005-03-22', 7000180),(181, 181, '2005-03-29', 7000181),(182, 182, '2005-04-05', 7000182),(183, 183, '2005-04-12', 7000183),(184, 184, '2005-04-19', 7000184),(185, 185, '2005-04-26', 7000185),(186, 186, '2005-05-03', 7000186),(187, 187, '2005-05-10', 7000187),(188, 188, '2005-05-17', 7000188),(189, 189, '2005-05-24', 7000189),(190, 190, '2005-05-31', 7000190),(191, 191, '2005-06-07', 7000191),(192, 192, '2005-06-14', 7000192),(193, 193, '2005-06-21', 7000193),(194, 194, '2005-06-28', 7000194),(195, 195, '2005-07-05', 7000195),(196, 196, '2005-07-12', 7000196),(197, 197, '2005-07-19', 7000197),(198, 198, '2005-07-26', 7000198),(199, 199, '2005-08-02', 7000199),(200, 200, '2005-08-09', 7000200),(201, 201, '2005-08-16', 7000201),(202, 202, '2005-08-23', 7000202),(203, 203, '2005-08-30', 7000203),(204, 204, '2005-09-06', 7000204),(205, 205, '2005-09-13', 7000205),(206, 206, '2005-09-20', 7000206),(207, 207, '2005-09-27', 7000207),(208, 208, '2005-10-04', 7000208),(209, 209, '2005-10-11', 7000209),(210, 210, '2005-10-18', 7000210),(211, 211, '2005-10-25', 7000211),(212, 212, '2005-11-01', 7000212),(213, 213, '2005-11-08', 7000213),(214, 214, '2005-11-15', 7000214),(215, 215, '2005-11-22', 7000215),(216, 216, '2005-11-29', 7000216),(217, 217, '2005-12-06', 7000217);

INSERT INTO EpisodeActors(EpisodeID, ActorID, RoleType) VALUES
(1, 1, 'Lead'),(1, 2, 'Lead'),(1, 3, 'Supporting'),(1, 4, 'Supporting'),(1, 5, 'Supporting'),(2, 1, 'Lead'),(2, 2, 'Lead'),(2, 3, 'Supporting'),(2, 4, 'Supporting'),(2, 5, 'Supporting'),(3, 1, 'Lead'),(3, 2, 'Lead'),(3, 3, 'Supporting'),(3, 4, 'Supporting'),(3, 5, 'Supporting'),(4, 1, 'Lead'),(4, 2, 'Lead'),(4, 3, 'Supporting'),(4, 4, 'Supporting'),(4, 5, 'Supporting'),(5, 1, 'Lead'),(5, 2, 'Lead'),(5, 3, 'Supporting'),(5, 4, 'Supporting'),(5, 5, 'Supporting'),(6, 1, 'Lead'),(6, 2, 'Lead'),(6, 3, 'Supporting'),(6, 4, 'Supporting'),(6, 5, 'Supporting'),(7, 1, 'Lead'),(7, 2, 'Lead'),(7, 3, 'Supporting'),(7, 4, 'Supporting'),(7, 5, 'Supporting'),(8, 1, 'Lead'),(8, 2, 'Lead'),(8, 3, 'Supporting'),(8, 4, 'Supporting'),(8, 5, 'Supporting'),(9, 1, 'Lead'),(9, 2, 'Lead'),(9, 3, 'Supporting'),(9, 4, 'Supporting'),(9, 5, 'Supporting'),(10, 1, 'Lead'),(10, 2, 'Lead'),(10, 3, 'Supporting'),(10, 4, 'Supporting'),(10, 5, 'Supporting'),(11, 1, 'Lead'),(11, 2, 'Lead'),(11, 3, 'Supporting'),(11, 4, 'Supporting'),(11, 5, 'Supporting'),(12, 1, 'Lead'),(12, 2, 'Lead'),(12, 3, 'Supporting'),(12, 4, 'Supporting'),(12, 5, 'Supporting'),(13, 1, 'Lead'),(13, 2, 'Lead'),(13, 3, 'Supporting'),(13, 4, 'Supporting'),(13, 5, 'Supporting'),(14, 1, 'Lead'),(14, 2, 'Lead'),(14, 3, 'Supporting'),(14, 4, 'Supporting'),(14, 5, 'Supporting'),(15, 1, 'Lead'),(15, 2, 'Lead'),(15, 3, 'Supporting'),(15, 4, 'Supporting'),(15, 5, 'Supporting'),(16, 1, 'Lead'),(16, 2, 'Lead'),(16, 3, 'Supporting'),(16, 4, 'Supporting'),(16, 5, 'Supporting'),(17, 1, 'Lead'),(17, 2, 'Lead'),(17, 3, 'Supporting'),(17, 4, 'Supporting'),(17, 5, 'Supporting'),(18, 1, 'Lead'),(18, 2, 'Lead'),(18, 3, 'Supporting'),(18, 4, 'Supporting'),(18, 5, 'Supporting'),(19, 1, 'Lead'),(19, 2, 'Lead'),(19, 3, 'Supporting'),(19, 4, 'Supporting'),(19, 5, 'Supporting'),(20, 1, 'Lead'),(20, 2, 'Lead'),(20, 3, 'Supporting'),(20, 4, 'Supporting'),(20, 5, 'Supporting'),(21, 1, 'Lead'),(21, 2, 'Lead'),(21, 3, 'Supporting'),(21, 4, 'Supporting'),(21, 5, 'Supporting'),(22, 1, 'Lead'),(22, 2, 'Lead'),(22, 3, 'Supporting'),(22, 4, 'Supporting'),(22, 5, 'Supporting'),(23, 1, 'Lead'),(23, 2, 'Lead'),(23, 3, 'Supporting'),(23, 4, 'Supporting'),(23, 5, 'Supporting'),(24, 1, 'Lead'),(24, 2, 'Lead'),(24, 3, 'Supporting'),(24, 4, 'Supporting'),(24, 5, 'Supporting'),(25, 1, 'Lead'),(25, 2, 'Lead'),(25, 3, 'Supporting'),(25, 4, 'Supporting'),(25, 5, 'Supporting'),(26, 1, 'Lead'),(26, 2, 'Lead'),(26, 3, 'Supporting'),(26, 4, 'Supporting'),(26, 5, 'Supporting'),(27, 1, 'Lead'),(27, 2, 'Lead'),(27, 3, 'Supporting'),(27, 4, 'Supporting'),(27, 5, 'Supporting'),(28, 1, 'Lead'),(28, 2, 'Lead'),(28, 3, 'Supporting'),(28, 4, 'Supporting'),(28, 5, 'Supporting'),(29, 1, 'Lead'),(29, 2, 'Lead'),(29, 3, 'Supporting'),(29, 4, 'Supporting'),(29, 5, 'Supporting'),(30, 1, 'Lead'),(30, 2, 'Lead'),(30, 3, 'Supporting'),(30, 4, 'Supporting'),(30, 5, 'Supporting'),(31, 1, 'Lead'),(31, 2, 'Lead'),(31, 3, 'Supporting'),(31, 4, 'Supporting'),(31, 5, 'Supporting'),(32, 1, 'Lead'),(32, 2, 'Lead'),(32, 3, 'Supporting'),(32, 4, 'Supporting'),(32, 5, 'Supporting'),(33, 1, 'Lead'),(33, 2, 'Lead'),(33, 3, 'Supporting'),(33, 4, 'Supporting'),(33, 5, 'Supporting'),(34, 1, 'Lead'),(34, 2, 'Lead'),(34, 3, 'Supporting'),(34, 4, 'Supporting'),(34, 5, 'Supporting'),(35, 1, 'Lead'),(35, 2, 'Lead'),(35, 3, 'Supporting'),(35, 4, 'Supporting'),(35, 5, 'Supporting'),(36, 1, 'Lead'),(36, 2, 'Lead'),(36, 3, 'Supporting'),(36, 4, 'Supporting'),(36, 5, 'Supporting'),(37, 1, 'Lead'),(37, 2, 'Lead'),(37, 3, 'Supporting'),(37, 4, 'Supporting'),(37, 5, 'Supporting'),(38, 1, 'Lead'),(38, 2, 'Lead'),(38, 3, 'Supporting'),(38, 4, 'Supporting'),(38, 5, 'Supporting'),(39, 1, 'Lead'),(39, 2, 'Lead'),(39, 3, 'Supporting'),(39, 4, 'Supporting'),(39, 5, 'Supporting'),(40, 1, 'Lead'),(40, 2, 'Lead'),(40, 3, 'Supporting'),(40, 4, 'Supporting'),(40, 5, 'Supporting'),(41, 1, 'Lead'),(41, 2, 'Lead'),(41, 3, 'Supporting'),(41, 4, 'Supporting'),(41, 5, 'Supporting'),(42, 1, 'Lead'),(42, 2, 'Lead'),(42, 3, 'Supporting'),(42, 4, 'Supporting'),(42, 5, 'Supporting'),(43, 1, 'Lead'),(43, 2, 'Lead'),(43, 3, 'Supporting'),(43, 4, 'Supporting'),(43, 5, 'Supporting'),(44, 1, 'Lead'),(44, 2, 'Lead'),(44, 3, 'Supporting'),(44, 4, 'Supporting'),(44, 5, 'Supporting'),(45, 1, 'Lead'),(45, 2, 'Lead'),(45, 3, 'Supporting'),(45, 4, 'Supporting'),(45, 5, 'Supporting'),(46, 1, 'Lead'),(46, 2, 'Lead'),(46, 3, 'Supporting'),(46, 4, 'Supporting'),(46, 5, 'Supporting'),(47, 1, 'Lead'),(47, 2, 'Lead'),(47, 3, 'Supporting'),(47, 4, 'Supporting'),(47, 5, 'Supporting'),(48, 1, 'Lead'),(48, 2, 'Lead'),(48, 3, 'Supporting'),(48, 4, 'Supporting'),(48, 5, 'Supporting'),(49, 1, 'Lead'),(49, 2, 'Lead'),(49, 3, 'Supporting'),(49, 4, 'Supporting'),(49, 5, 'Supporting'),(50, 1, 'Lead'),(50, 2, 'Lead'),(50, 3, 'Supporting'),(50, 4, 'Supporting'),(50, 5, 'Supporting'),(51, 1, 'Lead'),(51, 2, 'Lead'),(51, 3, 'Supporting'),(51, 4, 'Supporting'),(51, 5, 'Supporting'),(52, 1, 'Lead'),(52, 2, 'Lead'),(52, 3, 'Supporting'),(52, 4, 'Supporting'),(52, 5, 'Supporting'),(53, 1, 'Lead'),(53, 2, 'Lead'),(53, 3, 'Supporting'),(53, 4, 'Supporting'),(53, 5, 'Supporting'),(54, 1, 'Lead'),(54, 2, 'Lead'),(54, 3, 'Supporting'),(54, 4, 'Supporting'),(54, 5, 'Supporting'),(55, 1, 'Lead'),(55, 2, 'Lead'),(55, 3, 'Supporting'),(55, 4, 'Supporting'),(55, 5, 'Supporting'),(56, 1, 'Lead'),(56, 2, 'Lead'),(56, 3, 'Supporting'),(56, 4, 'Supporting'),(56, 5, 'Supporting'),(57, 1, 'Lead'),(57, 2, 'Lead'),(57, 3, 'Supporting'),(57, 4, 'Supporting'),(57, 5, 'Supporting'),(58, 1, 'Lead'),(58, 2, 'Lead'),(58, 3, 'Supporting'),(58, 4, 'Supporting'),(58, 5, 'Supporting'),(59, 1, 'Lead'),(59, 2, 'Lead'),(59, 3, 'Supporting'),(59, 4, 'Supporting'),(59, 5, 'Supporting'),(60, 1, 'Lead'),(60, 2, 'Lead'),(60, 3, 'Supporting'),(60, 4, 'Supporting'),(60, 5, 'Supporting'),(61, 1, 'Lead'),(61, 2, 'Lead'),(61, 3, 'Supporting'),(61, 4, 'Supporting'),(61, 5, 'Supporting'),(62, 1, 'Lead'),(62, 2, 'Lead'),(62, 3, 'Supporting'),(62, 4, 'Supporting'),(62, 5, 'Supporting'),(63, 1, 'Lead'),(63, 2, 'Lead'),(63, 3, 'Supporting'),(63, 4, 'Supporting'),(63, 5, 'Supporting'),(64, 1, 'Lead'),(64, 2, 'Lead'),(64, 3, 'Supporting'),(64, 4, 'Supporting'),(64, 5, 'Supporting'),(65, 1, 'Lead'),(65, 2, 'Lead'),(65, 3, 'Supporting'),(65, 4, 'Supporting'),(65, 5, 'Supporting'),(66, 1, 'Lead'),(66, 2, 'Lead'),(66, 3, 'Supporting'),(66, 4, 'Supporting'),(66, 5, 'Supporting'),(67, 1, 'Lead'),(67, 2, 'Lead'),(67, 3, 'Supporting'),(67, 4, 'Supporting'),(67, 5, 'Supporting'),(68, 1, 'Lead'),(68, 2, 'Lead'),(68, 3, 'Supporting'),(68, 4, 'Supporting'),(68, 5, 'Supporting'),(69, 1, 'Lead'),(69, 2, 'Lead'),(69, 3, 'Supporting'),(69, 4, 'Supporting'),(69, 5, 'Supporting'),(70, 1, 'Lead'),(70, 2, 'Lead'),(70, 3, 'Supporting'),(70, 4, 'Supporting'),(70, 5, 'Supporting'),(71, 1, 'Lead'),(71, 2, 'Lead'),(71, 3, 'Supporting'),(71, 4, 'Supporting'),(71, 5, 'Supporting'),(72, 1, 'Lead'),(72, 2, 'Lead'),(72, 3, 'Supporting'),(72, 4, 'Supporting'),(72, 5, 'Supporting'),(73, 1, 'Lead'),(73, 2, 'Lead'),(73, 3, 'Supporting'),(73, 4, 'Supporting'),(73, 5, 'Supporting'),(74, 1, 'Lead'),(74, 2, 'Lead'),(74, 3, 'Supporting'),(74, 4, 'Supporting'),(74, 5, 'Supporting'),(75, 1, 'Lead'),(75, 2, 'Lead'),(75, 3, 'Supporting'),(75, 4, 'Supporting'),(75, 5, 'Supporting'),(76, 1, 'Lead'),(76, 2, 'Lead'),(76, 3, 'Supporting'),(76, 4, 'Supporting'),(76, 5, 'Supporting'),(77, 1, 'Lead'),(77, 2, 'Lead'),(77, 3, 'Supporting'),(77, 4, 'Supporting'),(77, 5, 'Supporting'),(78, 1, 'Lead'),(78, 2, 'Lead'),(78, 3, 'Supporting'),(78, 4, 'Supporting'),(78, 5, 'Supporting'),(79, 1, 'Lead'),(79, 2, 'Lead'),(79, 3, 'Supporting'),(79, 4, 'Supporting'),(79, 5, 'Supporting'),(80, 1, 'Lead'),(80, 2, 'Lead'),(80, 3, 'Supporting'),(80, 4, 'Supporting'),(80, 5, 'Supporting'),(81, 1, 'Lead'),(81, 2, 'Lead'),(81, 3, 'Supporting'),(81, 4, 'Supporting'),(81, 5, 'Supporting'),(82, 1, 'Lead'),(82, 2, 'Lead'),(82, 3, 'Supporting'),(82, 4, 'Supporting'),(82, 5, 'Supporting'),(83, 1, 'Lead'),(83, 2, 'Lead'),(83, 3, 'Supporting'),(83, 4, 'Supporting'),(83, 5, 'Supporting'),(84, 1, 'Lead'),(84, 2, 'Lead'),(84, 3, 'Supporting'),(84, 4, 'Supporting'),(84, 5, 'Supporting'),(85, 1, 'Lead'),(85, 2, 'Lead'),(85, 3, 'Supporting'),(85, 4, 'Supporting'),(85, 5, 'Supporting'),(86, 1, 'Lead'),(86, 2, 'Lead'),(86, 3, 'Supporting'),(86, 4, 'Supporting'),(86, 5, 'Supporting'),(87, 1, 'Lead'),(87, 2, 'Lead'),(87, 3, 'Supporting'),(87, 4, 'Supporting'),(87, 5, 'Supporting'),(88, 1, 'Lead'),(88, 2, 'Lead'),(88, 3, 'Supporting'),(88, 4, 'Supporting'),(88, 5, 'Supporting'),(89, 1, 'Lead'),(89, 2, 'Lead'),(89, 3, 'Supporting'),(89, 4, 'Supporting'),(89, 5, 'Supporting'),(90, 1, 'Lead'),(90, 2, 'Lead'),(90, 3, 'Supporting'),(90, 4, 'Supporting'),(90, 5, 'Supporting'),(91, 1, 'Lead'),(91, 2, 'Lead'),(91, 3, 'Supporting'),(91, 4, 'Supporting'),(91, 5, 'Supporting'),(92, 1, 'Lead'),(92, 2, 'Lead'),(92, 3, 'Supporting'),(92, 4, 'Supporting'),(92, 5, 'Supporting'),(93, 1, 'Lead'),(93, 2, 'Lead'),(93, 3, 'Supporting'),(93, 4, 'Supporting'),(93, 5, 'Supporting'),(94, 1, 'Lead'),(94, 2, 'Lead'),(94, 3, 'Supporting'),(94, 4, 'Supporting'),(94, 5, 'Supporting'),(95, 1, 'Lead'),(95, 2, 'Lead'),(95, 3, 'Supporting'),(95, 4, 'Supporting'),(95, 5, 'Supporting'),(96, 1, 'Lead'),(96, 2, 'Lead'),(96, 3, 'Supporting'),(96, 4, 'Supporting'),(96, 5, 'Supporting'),(97, 1, 'Lead'),(97, 2, 'Lead'),(97, 3, 'Supporting'),(97, 4, 'Supporting'),(97, 5, 'Supporting'),(98, 1, 'Lead'),(98, 2, 'Lead'),(98, 3, 'Supporting'),(98, 4, 'Supporting'),(98, 5, 'Supporting'),(99, 1, 'Lead'),(99, 2, 'Lead'),(99, 3, 'Supporting'),(99, 4, 'Supporting'),(99, 5, 'Supporting'),(100, 1, 'Lead'),(100, 2, 'Lead'),(100, 3, 'Supporting'),(100, 4, 'Supporting'),(100, 5, 'Supporting'),(101, 1, 'Lead'),(101, 2, 'Lead'),(101, 3, 'Supporting'),(101, 4, 'Supporting'),(101, 5, 'Supporting'),(102, 1, 'Lead'),(102, 2, 'Lead'),(102, 3, 'Supporting'),(102, 4, 'Supporting'),(102, 5, 'Supporting'),(103, 1, 'Lead'),(103, 2, 'Lead'),(103, 3, 'Supporting'),(103, 4, 'Supporting'),(103, 5, 'Supporting'),(104, 1, 'Lead'),(104, 2, 'Lead'),(104, 3, 'Supporting'),(104, 4, 'Supporting'),(104, 5, 'Supporting'),(105, 1, 'Lead'),(105, 2, 'Lead'),(105, 3, 'Supporting'),(105, 4, 'Supporting'),(105, 5, 'Supporting'),(106, 1, 'Lead'),(106, 2, 'Lead'),(106, 3, 'Supporting'),(106, 4, 'Supporting'),(106, 5, 'Supporting'),(107, 1, 'Lead'),(107, 2, 'Lead'),(107, 3, 'Supporting'),(107, 4, 'Supporting'),(107, 5, 'Supporting'),(108, 1, 'Lead'),(108, 2, 'Lead'),(108, 3, 'Supporting'),(108, 4, 'Supporting'),(108, 5, 'Supporting'),(109, 1, 'Lead'),(109, 2, 'Lead'),(109, 3, 'Supporting'),(109, 4, 'Supporting'),(109, 5, 'Supporting'),(110, 1, 'Lead'),(110, 2, 'Lead'),(110, 3, 'Supporting'),(110, 4, 'Supporting'),(110, 5, 'Supporting'),(111, 1, 'Lead'),(111, 2, 'Lead'),(111, 3, 'Supporting'),(111, 4, 'Supporting'),(111, 5, 'Supporting'),(112, 1, 'Lead'),(112, 2, 'Lead'),(112, 3, 'Supporting'),(112, 4, 'Supporting'),(112, 5, 'Supporting'),(113, 1, 'Lead'),(113, 2, 'Lead'),(113, 3, 'Supporting'),(113, 4, 'Supporting'),(113, 5, 'Supporting'),(114, 1, 'Lead'),(114, 2, 'Lead'),(114, 3, 'Supporting'),(114, 4, 'Supporting'),(114, 5, 'Supporting'),(115, 1, 'Lead'),(115, 2, 'Lead'),(115, 3, 'Supporting'),(115, 4, 'Supporting'),(115, 5, 'Supporting'),(116, 1, 'Lead'),(116, 2, 'Lead'),(116, 3, 'Supporting'),(116, 4, 'Supporting'),(116, 5, 'Supporting'),(117, 1, 'Lead'),(117, 2, 'Lead'),(117, 3, 'Supporting'),(117, 4, 'Supporting'),(117, 5, 'Supporting'),(118, 1, 'Lead'),(118, 2, 'Lead'),(118, 3, 'Supporting'),(118, 4, 'Supporting'),(118, 5, 'Supporting'),(119, 1, 'Lead'),(119, 2, 'Lead'),(119, 3, 'Supporting'),(119, 4, 'Supporting'),(119, 5, 'Supporting'),(120, 1, 'Lead'),(120, 2, 'Lead'),(120, 3, 'Supporting'),(120, 4, 'Supporting'),(120, 5, 'Supporting'),(121, 1, 'Lead'),(121, 2, 'Lead'),(121, 3, 'Supporting'),(121, 4, 'Supporting'),(121, 5, 'Supporting'),(122, 1, 'Lead'),(122, 2, 'Lead'),(122, 3, 'Supporting'),(122, 4, 'Supporting'),(122, 5, 'Supporting'),(123, 1, 'Lead'),(123, 2, 'Lead'),(123, 3, 'Supporting'),(123, 4, 'Supporting'),(123, 5, 'Supporting'),(124, 1, 'Lead'),(124, 2, 'Lead'),(124, 3, 'Supporting'),(124, 4, 'Supporting'),(124, 5, 'Supporting'),(125, 1, 'Lead'),(125, 2, 'Lead'),(125, 3, 'Supporting'),(125, 4, 'Supporting'),(125, 5, 'Supporting'),(126, 1, 'Lead'),(126, 2, 'Lead'),(126, 3, 'Supporting'),(126, 4, 'Supporting'),(126, 5, 'Supporting'),(127, 1, 'Lead'),(127, 2, 'Lead'),(127, 3, 'Supporting'),(127, 4, 'Supporting'),(127, 5, 'Supporting'),(128, 1, 'Lead'),(128, 2, 'Lead'),(128, 3, 'Supporting'),(128, 4, 'Supporting'),(128, 5, 'Supporting'),(129, 1, 'Lead'),(129, 2, 'Lead'),(129, 3, 'Supporting'),(129, 4, 'Supporting'),(129, 5, 'Supporting'),(130, 1, 'Lead'),(130, 2, 'Lead'),(130, 3, 'Supporting'),(130, 4, 'Supporting'),(130, 5, 'Supporting'),(131, 1, 'Lead'),(131, 2, 'Lead'),(131, 3, 'Supporting'),(131, 4, 'Supporting'),(131, 5, 'Supporting'),(132, 1, 'Lead'),(132, 2, 'Lead'),(132, 3, 'Supporting'),(132, 4, 'Supporting'),(132, 5, 'Supporting'),(133, 1, 'Lead'),(133, 2, 'Lead'),(133, 3, 'Supporting'),(133, 4, 'Supporting'),(133, 5, 'Supporting'),(134, 1, 'Lead'),(134, 2, 'Lead'),(134, 3, 'Supporting'),(134, 4, 'Supporting'),(134, 5, 'Supporting'),(135, 1, 'Lead'),(135, 2, 'Lead'),(135, 3, 'Supporting'),(135, 4, 'Supporting'),(135, 5, 'Supporting'),(136, 1, 'Lead'),(136, 2, 'Lead'),(136, 3, 'Supporting'),(136, 4, 'Supporting'),(136, 5, 'Supporting'),(137, 1, 'Lead'),(137, 2, 'Lead'),(137, 3, 'Supporting'),(137, 4, 'Supporting'),(137, 5, 'Supporting'),(138, 1, 'Lead'),(138, 2, 'Lead'),(138, 3, 'Supporting'),(138, 4, 'Supporting'),(138, 5, 'Supporting'),(139, 1, 'Lead'),(139, 2, 'Lead'),(139, 3, 'Supporting'),(139, 4, 'Supporting'),(139, 5, 'Supporting'),(140, 1, 'Lead'),(140, 2, 'Lead'),(140, 3, 'Supporting'),(140, 4, 'Supporting'),(140, 5, 'Supporting'),(141, 1, 'Lead'),(141, 2, 'Lead'),(141, 3, 'Supporting'),(141, 4, 'Supporting'),(141, 5, 'Supporting'),(142, 1, 'Lead'),(142, 2, 'Lead'),(142, 3, 'Supporting'),(142, 4, 'Supporting'),(142, 5, 'Supporting'),(143, 1, 'Lead'),(143, 2, 'Lead'),(143, 3, 'Supporting'),(143, 4, 'Supporting'),(143, 5, 'Supporting'),(144, 1, 'Lead'),(144, 2, 'Lead'),(144, 3, 'Supporting'),(144, 4, 'Supporting'),(144, 5, 'Supporting'),(145, 1, 'Lead'),(145, 2, 'Lead'),(145, 3, 'Supporting'),(145, 4, 'Supporting'),(145, 5, 'Supporting'),(146, 1, 'Lead'),(146, 2, 'Lead'),(146, 3, 'Supporting'),(146, 4, 'Supporting'),(146, 5, 'Supporting'),(147, 1, 'Lead'),(147, 2, 'Lead'),(147, 3, 'Supporting'),(147, 4, 'Supporting'),(147, 5, 'Supporting'),(148, 1, 'Lead'),(148, 2, 'Lead'),(148, 3, 'Supporting'),(148, 4, 'Supporting'),(148, 5, 'Supporting'),(149, 1, 'Lead'),(149, 2, 'Lead'),(149, 3, 'Supporting'),(149, 4, 'Supporting'),(149, 5, 'Supporting'),(150, 1, 'Lead'),(150, 2, 'Lead'),(150, 3, 'Supporting'),(150, 4, 'Supporting'),(150, 5, 'Supporting'),(151, 1, 'Lead'),(151, 2, 'Lead'),(151, 3, 'Supporting'),(151, 4, 'Supporting'),(151, 5, 'Supporting'),(152, 1, 'Lead'),(152, 2, 'Lead'),(152, 3, 'Supporting'),(152, 4, 'Supporting'),(152, 5, 'Supporting'),(153, 1, 'Lead'),(153, 2, 'Lead'),(153, 3, 'Supporting'),(153, 4, 'Supporting'),(153, 5, 'Supporting'),(154, 1, 'Lead'),(154, 2, 'Lead'),(154, 3, 'Supporting'),(154, 4, 'Supporting'),(154, 5, 'Supporting'),(155, 1, 'Lead'),(155, 2, 'Lead'),(155, 3, 'Supporting'),(155, 4, 'Supporting'),(155, 5, 'Supporting'),(156, 1, 'Lead'),(156, 2, 'Lead'),(156, 3, 'Supporting'),(156, 4, 'Supporting'),(156, 5, 'Supporting'),(157, 1, 'Lead'),(157, 2, 'Lead'),(157, 3, 'Supporting'),(157, 4, 'Supporting'),(157, 5, 'Supporting'),(158, 1, 'Lead'),(158, 2, 'Lead'),(158, 3, 'Supporting'),(158, 4, 'Supporting'),(158, 5, 'Supporting'),(159, 1, 'Lead'),(159, 2, 'Lead'),(159, 3, 'Supporting'),(159, 4, 'Supporting'),(159, 5, 'Supporting'),(160, 1, 'Lead'),(160, 2, 'Lead'),(160, 3, 'Supporting'),(160, 4, 'Supporting'),(160, 5, 'Supporting'),(161, 1, 'Lead'),(161, 2, 'Lead'),(161, 3, 'Supporting'),(161, 4, 'Supporting'),(161, 5, 'Supporting'),(162, 1, 'Lead'),(162, 2, 'Lead'),(162, 3, 'Supporting'),(162, 4, 'Supporting'),(162, 5, 'Supporting'),(163, 1, 'Lead'),(163, 2, 'Lead'),(163, 3, 'Supporting'),(163, 4, 'Supporting'),(163, 5, 'Supporting'),(164, 1, 'Lead'),(164, 2, 'Lead'),(164, 3, 'Supporting'),(164, 4, 'Supporting'),(164, 5, 'Supporting'),(165, 1, 'Lead'),(165, 2, 'Lead'),(165, 3, 'Supporting'),(165, 4, 'Supporting'),(165, 5, 'Supporting'),(166, 1, 'Lead'),(166, 2, 'Lead'),(166, 3, 'Supporting'),(166, 4, 'Supporting'),(166, 5, 'Supporting'),(167, 1, 'Lead'),(167, 2, 'Lead'),(167, 3, 'Supporting'),(167, 4, 'Supporting'),(167, 5, 'Supporting'),(168, 1, 'Lead'),(168, 2, 'Lead'),(168, 3, 'Supporting'),(168, 4, 'Supporting'),(168, 5, 'Supporting'),(169, 1, 'Lead'),(169, 2, 'Lead'),(169, 3, 'Supporting'),(169, 4, 'Supporting'),(169, 5, 'Supporting'),(170, 1, 'Lead'),(170, 2, 'Lead'),(170, 3, 'Supporting'),(170, 4, 'Supporting'),(170, 5, 'Supporting'),(171, 1, 'Lead'),(171, 2, 'Lead'),(171, 3, 'Supporting'),(171, 4, 'Supporting'),(171, 5, 'Supporting'),(172, 1, 'Lead'),(172, 2, 'Lead'),(172, 3, 'Supporting'),(172, 4, 'Supporting'),(172, 5, 'Supporting'),(173, 1, 'Lead'),(173, 2, 'Lead'),(173, 3, 'Supporting'),(173, 4, 'Supporting'),(173, 5, 'Supporting'),(174, 1, 'Lead'),(174, 2, 'Lead'),(174, 3, 'Supporting'),(174, 4, 'Supporting'),(174, 5, 'Supporting'),(175, 1, 'Lead'),(175, 2, 'Lead'),(175, 3, 'Supporting'),(175, 4, 'Supporting'),(175, 5, 'Supporting'),(176, 1, 'Lead'),(176, 2, 'Lead'),(176, 3, 'Supporting'),(176, 4, 'Supporting'),(176, 5, 'Supporting'),(177, 1, 'Lead'),(177, 2, 'Lead'),(177, 3, 'Supporting'),(177, 4, 'Supporting'),(177, 5, 'Supporting'),(178, 1, 'Lead'),(178, 2, 'Lead'),(178, 3, 'Supporting'),(178, 4, 'Supporting'),(178, 5, 'Supporting'),(179, 1, 'Lead'),(179, 2, 'Lead'),(179, 3, 'Supporting'),(179, 4, 'Supporting'),(179, 5, 'Supporting'),(180, 1, 'Lead'),(180, 2, 'Lead'),(180, 3, 'Supporting'),(180, 4, 'Supporting'),(180, 5, 'Supporting'),(181, 1, 'Lead'),(181, 2, 'Lead'),(181, 3, 'Supporting'),(181, 4, 'Supporting'),(181, 5, 'Supporting'),(182, 1, 'Lead'),(182, 2, 'Lead'),(182, 3, 'Supporting'),(182, 4, 'Supporting'),(182, 5, 'Supporting'),(183, 1, 'Lead'),(183, 2, 'Lead'),(183, 3, 'Supporting'),(183, 4, 'Supporting'),(183, 5, 'Supporting'),(184, 1, 'Lead'),(184, 2, 'Lead'),(184, 3, 'Supporting'),(184, 4, 'Supporting'),(184, 5, 'Supporting'),(185, 1, 'Lead'),(185, 2, 'Lead'),(185, 3, 'Supporting'),(185, 4, 'Supporting'),(185, 5, 'Supporting'),(186, 1, 'Lead'),(186, 2, 'Lead'),(186, 3, 'Supporting'),(186, 4, 'Supporting'),(186, 5, 'Supporting'),(187, 1, 'Lead'),(187, 2, 'Lead'),(187, 3, 'Supporting'),(187, 4, 'Supporting'),(187, 5, 'Supporting'),(188, 1, 'Lead'),(188, 2, 'Lead'),(188, 3, 'Supporting'),(188, 4, 'Supporting'),(188, 5, 'Supporting'),(189, 1, 'Lead'),(189, 2, 'Lead'),(189, 3, 'Supporting'),(189, 4, 'Supporting'),(189, 5, 'Supporting'),(190, 1, 'Lead'),(190, 2, 'Lead'),(190, 3, 'Supporting'),(190, 4, 'Supporting'),(190, 5, 'Supporting'),(191, 1, 'Lead'),(191, 2, 'Lead'),(191, 3, 'Supporting'),(191, 4, 'Supporting'),(191, 5, 'Supporting'),(192, 1, 'Lead'),(192, 2, 'Lead'),(192, 3, 'Supporting'),(192, 4, 'Supporting'),(192, 5, 'Supporting'),(193, 1, 'Lead'),(193, 2, 'Lead'),(193, 3, 'Supporting'),(193, 4, 'Supporting'),(193, 5, 'Supporting'),(194, 1, 'Lead'),(194, 2, 'Lead'),(194, 3, 'Supporting'),(194, 4, 'Supporting'),(194, 5, 'Supporting'),(195, 1, 'Lead'),(195, 2, 'Lead'),(195, 3, 'Supporting'),(195, 4, 'Supporting'),(195, 5, 'Supporting'),(196, 1, 'Lead'),(196, 2, 'Lead'),(196, 3, 'Supporting'),(196, 4, 'Supporting'),(196, 5, 'Supporting'),(197, 1, 'Lead'),(197, 2, 'Lead'),(197, 3, 'Supporting'),(197, 4, 'Supporting'),(197, 5, 'Supporting'),(198, 1, 'Lead'),(198, 2, 'Lead'),(198, 3, 'Supporting'),(198, 4, 'Supporting'),(198, 5, 'Supporting'),(199, 1, 'Lead'),(199, 2, 'Lead'),(199, 3, 'Supporting'),(199, 4, 'Supporting'),(199, 5, 'Supporting'),(200, 1, 'Lead'),(200, 2, 'Lead'),(200, 3, 'Supporting'),(200, 4, 'Supporting'),(200, 5, 'Supporting'),(201, 1, 'Lead'),(201, 2, 'Lead'),(201, 3, 'Supporting'),(201, 4, 'Supporting'),(201, 5, 'Supporting'),(202, 1, 'Lead'),(202, 2, 'Lead'),(202, 3, 'Supporting'),(202, 4, 'Supporting'),(202, 5, 'Supporting'),(203, 1, 'Lead'),(203, 2, 'Lead'),(203, 3, 'Supporting'),(203, 4, 'Supporting'),(203, 5, 'Supporting'),(204, 1, 'Lead'),(204, 2, 'Lead'),(204, 3, 'Supporting'),(204, 4, 'Supporting'),(204, 5, 'Supporting'),(205, 1, 'Lead'),(205, 2, 'Lead'),(205, 3, 'Supporting'),(205, 4, 'Supporting'),(205, 5, 'Supporting'),(206, 1, 'Lead'),(206, 2, 'Lead'),(206, 3, 'Supporting'),(206, 4, 'Supporting'),(206, 5, 'Supporting'),(207, 1, 'Lead'),(207, 2, 'Lead'),(207, 3, 'Supporting'),(207, 4, 'Supporting'),(207, 5, 'Supporting'),(208, 1, 'Lead'),(208, 2, 'Lead'),(208, 3, 'Supporting'),(208, 4, 'Supporting'),(208, 5, 'Supporting'),(209, 1, 'Lead'),(209, 2, 'Lead'),(209, 3, 'Supporting'),(209, 4, 'Supporting'),(209, 5, 'Supporting'),(210, 1, 'Lead'),(210, 2, 'Lead'),(210, 3, 'Supporting'),(210, 4, 'Supporting'),(210, 5, 'Supporting'),(211, 1, 'Lead'),(211, 2, 'Lead'),(211, 3, 'Supporting'),(211, 4, 'Supporting'),(211, 5, 'Supporting'),(212, 1, 'Lead'),(212, 2, 'Lead'),(212, 3, 'Supporting'),(212, 4, 'Supporting'),(212, 5, 'Supporting'),(213, 1, 'Lead'),(213, 2, 'Lead'),(213, 3, 'Supporting'),(213, 4, 'Supporting'),(213, 5, 'Supporting'),(214, 1, 'Lead'),(214, 2, 'Lead'),(214, 3, 'Supporting'),(214, 4, 'Supporting'),(214, 5, 'Supporting'),(215, 1, 'Lead'),(215, 2, 'Lead'),(215, 3, 'Supporting'),(215, 4, 'Supporting'),(215, 5, 'Supporting'),(216, 1, 'Lead'),(216, 2, 'Lead'),(216, 3, 'Supporting'),(216, 4, 'Supporting'),(216, 5, 'Supporting'),(217, 1, 'Lead'),(217, 2, 'Lead'),(217, 3, 'Supporting'),(217, 4, 'Supporting'),(217, 5, 'Supporting');


ALTER TABLE Episodes
ADD COLUMN EpisodeName VARCHAR(30);

CREATE VIEW EpisodeDetails 
SELECT Title, SeasonNumber, EpisodeNumber, AirDate, DirectorName
FROM Episodes;