======================= Homework 9 Problem 3 ======================= Your Name ************ problem 3-1 CATEGORY_N NUM_VIDEOS ---------- ---------- Action 20 Family 10 Classic 6 Drama 5 Comedy 1 ************ problem 3-2 View dropped. View created. ************ problem 3-3 CLIENT_LNAME FAVE_CATEG --------------- ---------- Alpha Comedy Beta Action Carlos Drama Delta Classic Epsilon Classic Feta Family Greta Action Harpo Comedy 8 rows selected. FAVE_CATEG CLIENT_LNAME ---------- --------------- Action Beta Action Greta Classic Delta Classic Epsilon Comedy Alpha Comedy Harpo Drama Carlos Family Feta 8 rows selected. ************ problem 3-4 View dropped. View created. ************ problem 3-5 CATEGORY_N MOVIE MOVIE_TITLE ---------- ----- ---------------------------------------- Action PG Indiana Jones and the Temple of Doom Action PG Return of the Jedi Action PG Star Wars Action PG The Empire Strikes Back Action PG The Phantom Menace Action PG-13 Indiana Jones and the Last Crusade Action R The Matrix Classic G All About Eve Classic G Gone with the Wind Classic G It's a Wonderful Life Classic G The Philadelphia Story CATEGORY_N MOVIE MOVIE_TITLE ---------- ----- ---------------------------------------- Comedy R The Blues Brothers Drama A Clockwork Orange Drama A Midnight Cowboy Drama R Fatal Attraction Drama R One Flew Over the Cuckoo's Nest Family G Babe Family G The Muppet Movie Family G Toy Story Family G Toy Story 2 20 rows selected. ************ problem 3-6 CATEGORY_N CATEGORY_QUANT ---------- -------------- Action 7 Classic 4 Family 4 Drama 4 Comedy 1 ===== Problem 3-7 ===== CLIENT_LNAME CATEGORY_N CLIENT_CREDIT_RTG --------------- ---------- ----------------- Alpha Comedy 4.9 Harpo Comedy 3.3 Greta Action 4.4 Carlos Drama 3.8 Delta Classic 3.4 ===== Problem 3-8 ===== VID_ID MOVIE_TITLE VID_FOR ------ ---------------------------------------- ------- 120021 It's a Wonderful Life Blu-Ray 220021 Indiana Jones and the Last Crusade Blu-Ray 330012 Babe DVD 320011 Babe Blu-Ray 320022 Toy Story Blu-Ray 320021 Toy Story Blu-Ray 330034 Toy Story 2 DVD 330033 Toy Story 2 DVD 320031 Toy Story 2 Blu-Ray 220032 Star Wars Blu-Ray 230043 The Empire Strikes Back DVD VID_ID MOVIE_TITLE VID_FOR ------ ---------------------------------------- ------- 220042 The Empire Strikes Back Blu-Ray 230052 Return of the Jedi DVD 220051 Return of the Jedi Blu-Ray 230064 The Phantom Menace DVD 220063 The Phantom Menace Blu-Ray 220061 The Phantom Menace Blu-Ray 420021 Midnight Cowboy Blu-Ray 420031 Clockwork Orange Blu-Ray 120041 All About Eve Blu-Ray 120051 The Philadelphia Story Blu-Ray 420042 Fatal Attraction Blu-Ray VID_ID MOVIE_TITLE VID_FOR ------ ---------------------------------------- ------- 410041 Fatal Attraction HD-DVD 230074 The Matrix DVD 230073 The Matrix DVD 220072 The Matrix Blu-Ray 220071 The Matrix Blu-Ray 130061 The Blues Brothers DVD 28 rows selected.