Homework 6 - Problem 2
<your name should appear here>
===== Problem 2-1 =====
Rating: Movie
-----------------------------------------------
G: Gone with the Wind
G: It's a Wonderful Life
G: The Muppet Movie
PG: Indiana Jones and the Temple of Doom
PG-13: Indiana Jones and the Last Crusade
G: Babe
G: Toy Story
G: Toy Story 2
PG: Star Wars
PG: The Empire Strikes Back
PG: Return of the Jedi
Rating: Movie
-----------------------------------------------
PG: The Phantom Menace
R: One Flew Over the Cuckoo's Nest
A: Midnight Cowboy
A: Clockwork Orange
G: All About Eve
G: The Philadelphia Story
R: Fatal Attraction
R: The Matrix
R: The Blues Brothers
20 rows selected.
===== Problem 2-2 =====
Movies
-----------------------------------------------
Gone with the Wind (1939)
It's a Wonderful Life (1947)
The Muppet Movie (1979)
Indiana Jones and the Temple of Doom (1984)
Indiana Jones and the Last Crusade (1989)
Babe (1995)
Toy Story (1995)
Toy Story 2 (1999)
Star Wars (1977)
The Empire Strikes Back (1980)
Return of the Jedi (1983)
Movies
-----------------------------------------------
The Phantom Menace (1999)
One Flew Over the Cuckoo's Nest (1975)
Midnight Cowboy (1969)
Clockwork Orange (1971)
All About Eve (1950)
The Philadelphia Story (1940)
Fatal Attraction (1987)
The Matrix (1999)
The Blues Brothers (1980)
20 rows selected.
===== Problem 2-3 =====
CLIENT_LNAME CLIENT_P CLIENT_CREDIT_RTG
--------------- -------- -----------------
Alpha 111-1111 4.9
Beta 222-2222 1.2
Carlos 333-3333 3.8
Beta 555-5555 5
Epsilon 666-6666 2.1
Greta 888-8888 4.4
6 rows selected.
===== Problem 2-4 =====
MOVIE_TITLE
----------------------------------------
The Muppet Movie
The Blues Brothers
===== Problem 2-5 =====
# never rented their avg rental price
-------------- ----------------------
28 3.10071429
===== Problem 2-6 =====
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.