case statement – Global Homework Experts

SQL Query1.sql – 10….5333 (dkh5333 (53)) = X e select from Theater Normalized select from Movies select from MovieSchedule select from MovieActors 100 % Results il Messages ID TheaterName Address City State ZpCode 1 1 AMC Waterfront 22 300 Waterfront Dive W Homestead PA 15120 2 3 AMC Classic Mount Lebanon 6 1500 Washington Rd M. Lebanon PA 15228 3 4 Waterworks nema 923 Freeport Rd Petsburgh PA 15238 5 AMC Classic South Hils Village 10 700 R. Couch Rd Pittsburgh PA 15241 5 6 Cnemark Robinson Township and XD 2100 Settlers Ridge Center Drive Petsburgh PA 15205 6 7 Cnemark Monroevile Mal and XD 600 Monroeville Mall Monroeville PA 15146 WN – 4 1 2 3 4 5 6 ID Movie Name 1 Wonder Woman 1984 2 Tom and Jerry 3 Ghostbusters: After fe 4 Morbius 5 F9 6 Mortal Kombat 7 Black Widow 8 Godzilla Vs Kong 9 Venom: Let There Be Camage 10 Tenet 11 The Croods: A New Age Release Date 2020-12-25 2021-02-26 2021-03-05 2021-03-19 2021-04-02 2021-04-16 2021-05-07 2021-05-21 2021-06-25 2020-09-03 2020-11-25 Rating Run Time_Minutes 3 151 1 96 3 125 3 137 3 128 4 100 3 129 4 144 4 147 3 150 6 95 7 ? 9 10 11 3 select from MovieSchedule select from MovieActors 100 % Results Messages Theater D Movie Movie Time 1 1 1 2020-12-25 19:00:00.000 2. 1 1 2020-12-25 22:00:00.000 3 2 1 2020-12-25 19:00:00.000 4 2 1 2020-12-25 21:00:00.000 5 3 1 2020-12-25 19:00:00.000 6 3 1 2020-12-25 21:00:00.000 7 1 10 2020-12-25 13:00:00.000 8 4 10 2020-12-25 18:00:00.000 5 15 2020-12-25 14:00:00.000 10 1 1 2020-12-26 19:00:00.000 11 1 1 2020-12-27 19:00:00.000 12 1 2020-12-26 22:00:00.000 9 3 1 2 3 4 5 6 7 8 9 ID ActorName MovieHD FilmCharacter 1 Gal Gadot 1 Wonder Woman 2 Tom Holand 9 Spiderman 3 Tom Holland Spiderman 4 Vin Diesel 5 Dominic Toretto 5 Scarlett Johansson 7 Natasha Romanoff 6 Tom Hardy 9 Venom 7 Hiroyuki Sanada 6 Scorpion 8 Ludi Un 6 Lu Kang 9 Daniel Nelson 6 Kabal 10 Sisi Stringer 6 Mleena 11 Josh Lawson 6 Kano 10 11 /*2. (3pts) Create a function that when used would replace an e with a 1 –You are going to use the built in ‘replace’ function in your user defined function/ –3. (2pts) Write a SQL statement using your function you just created to return MovieNames with the e’s replaced. /*4. (5 pts) Using a case statement in SQL to return the ActorName, MovieName, Filmcharacter but when you see Tom Holland make his name Toby Maguire.. USING CASE STATEMENT NOT REPLACE/

order now

Comments are closed.