Question

7 Serenity 28.99 15.99 IM Sales You run a small online store that sells movies to the public. Your database is called Movies and looks like the image below: Recordio Title Sale Distributor Category Rating 1 Happy Gilmore 20.99 15.99 M Sales 10 Blu Ray Combo Pad Comedy PG 22 Transformers: The Last Bright 25.99 1799 Discountu 1246 3 Cars 3 30.99 17.99 Movie Place 14 Bu Ray Animated G 4 Thomas Crown Hair 26,99 19.99 Blu-Ray Emporium 17 Blu-Ray Como Pad Drama Kingdom of Heaves 26.99 21.99 Discountbu 194% 6 Talledega Nights 2799 1099 Blu-Ray Boutique 10 BluRay Combo Pad Comedy PG-13 Action PG-13 100 20.99 10.99 Movie Place 15146 Inside Out 25.99 12.99 Blu-Ray Boutique 13 BluRay 10 Gladiator 30.99 17.99 Movie Boutique 20 BluRay Combo Pack Drama 11 ndara Jones and the Kingdom of the Crystal Skal 28.99 1999 Blu-Ray Emporium 10 Blu Ray Adventure PG 13 12 The Hangover 27.99 15.99 Discourlu 19Bu-Ray Combo Pace Comedy 13. Daddy 125.99 1099 Movie Place 21 Bu Ray Combo Pack Comedy PG 14 Pirates of the Carbbean: Dead Men Tell No Tales 2299 219 IM Sales 228 Ra d venture PG-13 15 Crimson Tide 20.99 1395 Blu-Ray Emporun 1 Blu Ray Combo Pad Drama 16 Iron Man 3 30.99 1259 More Emporum 10 Blu-Ray Action PG-13 17 loe Dint 2299 1799 Blu Ray Boutique 12 Blu Ray Combo Pad Comedy PG 18 Shret Forever After 3559 19.99 18Sales 1346 Animated PG 19 Dead Poets Society 2799 2199 Movie Place 178-Ray Combo Pack Drama 20 Swordfish 19.99 1299 Discount Movies 20 Bu-Ray Combo Pack ActionR 21 Office Space 2099 1599 1B Sales 1 3 BuRay Combo Pack Comedy 22 Toy Story 3 26.99 13.99 Movie Place 10 Blu-Ray Combo Pad Animated s 23 The Mummy 19.99 12:59 Blu-Ray Emporium 21 Blu Ray Combo Pad Adventure PG-13 24 Justice League 19.99 19.99 IM Sales 194K Action PG-13 25 Wedding Crashers 30.99 13.59 Blu-Ray Boutique 104K Comedy 25 Pulp Fiction 28.99 2199 Discount Blu 12 Blu-Ray Combo Pack Drama 27 Sin City 25.59 1395 Discount Movies 15 Blu Ray Combo Pad Drama 28 Finding Nemo 26.99 12.99 M Sales 15 Blu-Ray Combo Pace Animated 29 Down Periscope 2799 1799 Movie Place 19 Bu-Ray Conto Pad Comedy AG 3. National True 25.99 1999 Discountu 13 BluRay Adventure PG ESSE For each question below, please write the SQL query that will get you the answer being sought: Please retrieve all of the data for movies that have a list price of 19.99 xi BIO E E FER

Answer 1

1- QUERY TO RETRIEVE ALL OF THE DATA FOR MOVIES THAT HAVE A LIST PRICE OF 19.99

SELECT * FROM movies WHERE List=19.99

2- QUERY TO RETRIEVE RECORD NUMBER AND LIST PRICE INFORMATION FOR ALL MOVIES THAT ARE RATED PG-13

SELECT RecordID, List FROM movies WHERE Rating='PG-13'

3- QUERY TO RETRIEVE MOVIE TITLE FOR ALL MOVES THAT COME FROM BLU-RAY BOUTIQUE AND WHERE THERE ARE ONLY 10 COPIES OF THE MOVIE

SELECT Title FROM movies WHERE (Distributor= 'Blu-Ray Boutique' AND Quantity= 10)

4-  QUERY TO RETRIEVE TITLE AND DISTRIBUTOR INFORMATION FOR ALL ANIMATED TITLES THAT ARE PG-13

SELECT Title, Distributor FROM movies WHERE (Category='Animated' AND Rating='PG-13' )

5- QUERY TO GET TITLE, RECORD NUMBER AND DISTRIBUTOR FOR ALL 4K MOVIES THAT ARE RATED R

SELECT Title, RecordID, Distributor FROM movies WHERE (Type='4K' AND Rating='R')

HAPPY LEARNING