Homework 4 Problem 1
<your name should appear here>
===== Problem 1-1 =====
CLIE CLIENT_LNAME CLIENT_FNAME CLIENT_P CLIENT_CREDIT_RTG CLI
---- --------------- --------------- -------- ----------------- ---
2222 Beta Bob 222-2222 1.2 200
6666 Epsilon Emma 666-6666 2.1 400
7777 Feta Frank 777-7777 0 500
9999 Harpo Harry 999-9999 3.3 100
===== Problem 1-2 =====
MOVIE MOVI
----- ----
PG-13 1989
G 1999
A 1969
G 1979
R 1975
R 1987
PG 1983
PG 1999
G 1940
PG 1977
PG 1980
MOVIE MOVI
----- ----
R 1980
G 1950
R 1999
G 1939
G 1947
G 1995
A 1971
PG 1984
19 rows selected.
===== Problem 1-3 =====
CLIE CLIENT_LNAME CLIENT_FNAME CLIENT_P CLIENT_CREDIT_RTG CLI CAT
---- --------------- --------------- -------- ----------------- --- ---
CATEGORY_N
----------
1111 Alpha Ann 111-1111 4.9 100 100
Comedy
2222 Beta Bob 222-2222 1.2 200 200
Action
3333 Carlos Ann 333-3333 3.8 300 300
Drama
CLIE CLIENT_LNAME CLIENT_FNAME CLIENT_P CLIENT_CREDIT_RTG CLI CAT
---- --------------- --------------- -------- ----------------- --- ---
CATEGORY_N
----------
4444 Delta David 222-2222 3.4 400 400
Classic
6666 Epsilon Emma 666-6666 2.1 400 400
Classic
7777 Feta Frank 777-7777 0 500 500
Family
CLIE CLIENT_LNAME CLIENT_FNAME CLIENT_P CLIENT_CREDIT_RTG CLI CAT
---- --------------- --------------- -------- ----------------- --- ---
CATEGORY_N
----------
8888 Greta Gail 888-8888 4.4 200 200
Action
9999 Harpo Harry 999-9999 3.3 100 100
Comedy
8 rows selected.
===== Problem 1-4 =====
VID_ID DATE_DUE
------ ---------
130031 22-SEP-16
130012 22-SEP-16
210011 11-AUG-16
230012 10-SEP-16
220013 25-SEP-16
220062 26-SEP-16
210011 17-SEP-16
7 rows selected.
===== Problem 1-5 =====
VID_ID VID_FOR VID_RENTAL_PRICE
------ ------- ----------------
120011 Blu-Ray 2.99
120021 Blu-Ray 1.99
210011 HD-DVD .99
220013 Blu-Ray 2.19
220021 Blu-Ray 2.19
320011 Blu-Ray 1.99
320021 Blu-Ray 1.99
320022 Blu-Ray 1.99
320031 Blu-Ray 2.99
320032 Blu-Ray 2.99
210031 HD-DVD .99
VID_ID VID_FOR VID_RENTAL_PRICE
------ ------- ----------------
220032 Blu-Ray 1.99
210041 HD-DVD 1.29
220042 Blu-Ray 1.99
220051 Blu-Ray 1.99
220061 Blu-Ray 2.99
220062 Blu-Ray 2.99
220063 Blu-Ray 2.99
420011 Blu-Ray 2.19
420021 Blu-Ray 2.19
420031 Blu-Ray 2.19
120041 Blu-Ray 1.99
VID_ID VID_FOR VID_RENTAL_PRICE
------ ------- ----------------
120051 Blu-Ray 1.99
410041 HD-DVD 1.29
420042 Blu-Ray 2.19
220071 Blu-Ray 2.99
220072 Blu-Ray 2.99
27 rows selected.
===== Problem 1-6 =====
CATEGORY_N CLIENT_LNAME CLIENT_CREDIT_RTG
---------- --------------- -----------------
Comedy Alpha 4.9
Action Beta 1.2
Drama Carlos 3.8
Classic Delta 3.4
Classic Epsilon 2.1
Family Feta 0
Action Greta 4.4
Comedy Harpo 3.3
8 rows selected.
===== Problem 1-7 =====
VID_ID VID_FOR VID_PURCH VID_RENTAL_PRICE MOVIE
------ ------- --------- ---------------- -----
120011 Blu-Ray 11-JAN-10 2.99 10001
130012 DVD 22-FEB-11 4.99 10001
120021 Blu-Ray 03-MAR-09 1.99 10002
130031 DVD 22-FEB-11 4.99 10003
130061 DVD 15-JAN-10 1.99 10006
210011 HD-DVD 05-MAY-09 .99 20001
230012 DVD 01-JAN-10 3.99 20001
330012 DVD 08-MAY-10 3.99 30001
330023 DVD 07-JUN-09 4.99 30002
320031 Blu-Ray 01-DEC-11 2.99 30003
320032 Blu-Ray 01-DEC-11 2.99 30003
VID_ID VID_FOR VID_PURCH VID_RENTAL_PRICE MOVIE
------ ------- --------- ---------------- -----
220032 Blu-Ray 15-JUL-08 1.99 20003
230033 DVD 17-AUG-10 3.99 20003
220042 Blu-Ray 15-JUL-08 1.99 20004
230043 DVD 17-AUG-10 3.99 20004
220051 Blu-Ray 15-JUL-08 1.99 20005
230052 DVD 17-AUG-10 3.99 20005
220061 Blu-Ray 01-DEC-11 2.99 20006
220062 Blu-Ray 01-DEC-11 2.99 20006
220063 Blu-Ray 01-DEC-11 2.99 20006
230064 DVD 01-DEC-11 5.99 20006
420011 Blu-Ray 04-OCT-10 2.19 40001
VID_ID VID_FOR VID_PURCH VID_RENTAL_PRICE MOVIE
------ ------- --------- ---------------- -----
420021 Blu-Ray 04-OCT-10 2.19 40002
420031 Blu-Ray 04-OCT-10 2.19 40003
120041 Blu-Ray 04-OCT-10 1.99 10004
120051 Blu-Ray 04-OCT-10 1.99 10005
26 rows selected.
===== Problem 1-8 =====
VID_ID VID_FOR VID_PURCH VID_RENTAL_PRICE MOVIE
------ ------- --------- ---------------- -----
130012 DVD 22-FEB-11 4.99 10001
130022 DVD 04-MAR-12 5.99 10002
130031 DVD 22-FEB-11 4.99 10003
330033 DVD 05-MAY-12 5.99 30003
330034 DVD 05-MAY-12 5.99 30003
230064 DVD 01-DEC-11 5.99 20006
230073 DVD 15-MAR-12 5.99 20007
230074 DVD 15-MAR-12 5.99 20007
8 rows selected.
===== Problem 1-9 =====
MOVIE_TITLE MOVIE
---------------------------------------- -----
Gone with the Wind G
Indiana Jones and the Temple of Doom PG
Indiana Jones and the Last Crusade PG-13
Return of the Jedi PG
One Flew Over the Cuckoo's Nest R
The Blues Brothers R
6 rows selected.
===== Problem 1-10 =====
VID_ID VID_FOR PRICE_IF_REDUCED
------ ------- ----------------
120011 Blu-Ray 2.392
120021 Blu-Ray 1.592
210011 HD-DVD .792
220013 Blu-Ray 1.752
220021 Blu-Ray 1.752
320011 Blu-Ray 1.592
320021 Blu-Ray 1.592
320022 Blu-Ray 1.592
320031 Blu-Ray 2.392
320032 Blu-Ray 2.392
210031 HD-DVD .792
VID_ID VID_FOR PRICE_IF_REDUCED
------ ------- ----------------
220032 Blu-Ray 1.592
210041 HD-DVD 1.032
220042 Blu-Ray 1.592
220051 Blu-Ray 1.592
220061 Blu-Ray 2.392
220062 Blu-Ray 2.392
220063 Blu-Ray 2.392
420011 Blu-Ray 1.752
420021 Blu-Ray 1.752
420031 Blu-Ray 1.752
120041 Blu-Ray 1.592
VID_ID VID_FOR PRICE_IF_REDUCED
------ ------- ----------------
120051 Blu-Ray 1.592
410041 HD-DVD 1.032
420042 Blu-Ray 1.752
220071 Blu-Ray 2.392
220072 Blu-Ray 2.392
27 rows selected.
===== Problem 1-11 =====
MOVIE_TITLE MOVIE
---------------------------------------- -----
Indiana Jones and the Last Crusade PG-13
One Flew Over the Cuckoo's Nest R
Midnight Cowboy A
Clockwork Orange A
Fatal Attraction R
The Matrix R
The Blues Brothers R
7 rows selected.
===== Problem 1-12 =====
Num Vids Avg Rental
---------- ----------
42 3.15190476