Please send questions to
st10@humboldt.edu .
************
problem 2-3
MOVIE MOVIE_TITLE MOVIE
----- ---------------------------------------- -----
20002 Indiana Jones and the Last Crusade PG-13
20001 Indiana Jones and the Temple of Doom PG
20005 Return of the Jedi PG
20003 Star Wars PG
20004 The Empire Strikes Back PG
20007 The Matrix R
20006 The Phantom Menace PG
************
problem 2-4
CATEGORY_N MOVIE MOVIE_TITLE
---------- ----- ----------------------------------------
Drama A Clockwork Orange
Drama A Midnight Cowboy
Classic G All About Eve
Family G Babe
Classic G Gone with the Wind
Classic G It's a Wonderful Life
Family G The Muppet Movie
Classic G The Philadelphia Story
Family G Toy Story
Family G Toy Story 2
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
Drama R Fatal Attraction
Drama R One Flew Over the Cuckoo's Nest
Comedy R The Blues Brothers
Action R The Matrix
************
problem 2-5
CLIENT_NAME MOVIE_TITLE VID_FOR VID_RENTAL_PRICE
-------------------------------- ---------------------------------------- ------- ----------------
Alpha, Ann It's a Wonderful Life DVD 5.99
Beta, Bob Gone with the Wind DVD 4.99
Beta, Bob The Muppet Movie DVD 4.99
Beta, Bob Toy Story DVD 4.99
Carlos, Ann Gone with the Wind DVD 4.99
Epsilon, Emma Gone with the Wind DVD 4.99
Feta, Frank The Muppet Movie DVD 4.99
Feta, Frank The Muppet Movie DVD 4.99
Greta, Gail Indiana Jones and the Temple of Doom DVD 3.99
Harpo, Harry Star Wars DVD 3.99
Alpha, Ann The Phantom Menace Blu-Ray 2.99
Beta, Edie Gone with the Wind Blu-Ray 2.99
Carlos, Ann Gone with the Wind Blu-Ray 2.99
Carlos, Ann Toy Story 2 Blu-Ray 2.99
Delta, David Gone with the Wind Blu-Ray 2.99
Feta, Frank Gone with the Wind Blu-Ray 2.99
Beta, Edie Indiana Jones and the Temple of Doom Blu-Ray 2.19
Carlos, Ann One Flew Over the Cuckoo's Nest Blu-Ray 2.19
Harpo, Harry The Empire Strikes Back HD-DVD 1.29
Beta, Edie Star Wars HD-DVD .99
Carlos, Ann Indiana Jones and the Temple of Doom HD-DVD .99
Epsilon, Emma Indiana Jones and the Temple of Doom HD-DVD .99
Harpo, Harry Star Wars HD-DVD .99
************
problem 2-6
CATEGORY_N NUM_VIDEOS AVG_RENTAL_PRICE
---------- ---------- ----------------
Action 20 3.125
Family 10 3.79
Classic 6 3.32333333
Drama 5 2.01
Comedy 1 1.99
************
problem 2-7
===================
2-7 part a
CATEGORY_N NUM_VIDEOS AVG_RENTAL_PRICE
---------- ---------- ----------------
Action 20 2.63
Family 10 3.295
Classic 6 2.66333333
Drama 5 1.218
Comedy 1 1.99
===================
2-7 part b
CLIENT_NAME
--------------------------------
Beta, Bob
Beta, Edie
Carlos, Ann
Delta, David
Epsilon, Emma
Feta, Frank
===================
2-7 part c
CLIENT_NAME
--------------------------------
Beta, Bob
Carlos, Ann
Delta, David
Epsilon, Emma
Feta, Frank
===================
2-7 part d
CLIENT_NAME COUNT(*)
-------------------------------- ----------
Carlos, Ann 5
Beta, Bob 3
Feta, Frank 3
Harpo, Harry 3
Alpha, Ann 2
Epsilon, Emma 2
Delta, David 1
Greta, Gail 1
************
problem 2-8