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
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.
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 100
Comedy
3333 Carlos Ann 333-3333 3.8 300 100
Comedy
CLIE CLIENT_LNAME CLIENT_FNAME CLIENT_P CLIENT_CREDIT_RTG CLI CAT
---- --------------- --------------- -------- ----------------- --- ---
CATEGORY_N
----------
4444 Delta David 222-2222 3.4 400 100
Comedy
5555 Beta Edie 555-5555 5 100
Comedy
6666 Epsilon Emma 666-6666 2.1 400 100
Comedy
CLIE CLIENT_LNAME CLIENT_FNAME CLIENT_P CLIENT_CREDIT_RTG CLI CAT
---- --------------- --------------- -------- ----------------- --- ---
CATEGORY_N
----------
7777 Feta Frank 777-7777 0 500 100
Comedy
8888 Greta Gail 888-8888 4.4 200 100
Comedy
9999 Harpo Harry 999-9999 3.3 100 100
Comedy
CLIE CLIENT_LNAME CLIENT_FNAME CLIENT_P CLIENT_CREDIT_RTG CLI CAT
---- --------------- --------------- -------- ----------------- --- ---
CATEGORY_N
----------
1111 Alpha Ann 111-1111 4.9 100 200
Action
2222 Beta Bob 222-2222 1.2 200 200
Action
3333 Carlos Ann 333-3333 3.8 300 200
Action
CLIE CLIENT_LNAME CLIENT_FNAME CLIENT_P CLIENT_CREDIT_RTG CLI CAT
---- --------------- --------------- -------- ----------------- --- ---
CATEGORY_N
----------
4444 Delta David 222-2222 3.4 400 200
Action
5555 Beta Edie 555-5555 5 200
Action
6666 Epsilon Emma 666-6666 2.1 400 200
Action
CLIE CLIENT_LNAME CLIENT_FNAME CLIENT_P CLIENT_CREDIT_RTG CLI CAT
---- --------------- --------------- -------- ----------------- --- ---
CATEGORY_N
----------
7777 Feta Frank 777-7777 0 500 200
Action
8888 Greta Gail 888-8888 4.4 200 200
Action
9999 Harpo Harry 999-9999 3.3 100 200
Action
CLIE CLIENT_LNAME CLIENT_FNAME CLIENT_P CLIENT_CREDIT_RTG CLI CAT
---- --------------- --------------- -------- ----------------- --- ---
CATEGORY_N
----------
1111 Alpha Ann 111-1111 4.9 100 300
Drama
2222 Beta Bob 222-2222 1.2 200 300
Drama
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 300
Drama
5555 Beta Edie 555-5555 5 300
Drama
6666 Epsilon Emma 666-6666 2.1 400 300
Drama
CLIE CLIENT_LNAME CLIENT_FNAME CLIENT_P CLIENT_CREDIT_RTG CLI CAT
---- --------------- --------------- -------- ----------------- --- ---
CATEGORY_N
----------
7777 Feta Frank 777-7777 0 500 300
Drama
8888 Greta Gail 888-8888 4.4 200 300
Drama
9999 Harpo Harry 999-9999 3.3 100 300
Drama
CLIE CLIENT_LNAME CLIENT_FNAME CLIENT_P CLIENT_CREDIT_RTG CLI CAT
---- --------------- --------------- -------- ----------------- --- ---
CATEGORY_N
----------
1111 Alpha Ann 111-1111 4.9 100 400
Classic
2222 Beta Bob 222-2222 1.2 200 400
Classic
3333 Carlos Ann 333-3333 3.8 300 400
Classic
CLIE CLIENT_LNAME CLIENT_FNAME CLIENT_P CLIENT_CREDIT_RTG CLI CAT
---- --------------- --------------- -------- ----------------- --- ---
CATEGORY_N
----------
4444 Delta David 222-2222 3.4 400 400
Classic
5555 Beta Edie 555-5555 5 400
Classic
6666 Epsilon Emma 666-6666 2.1 400 400
Classic
CLIE CLIENT_LNAME CLIENT_FNAME CLIENT_P CLIENT_CREDIT_RTG CLI CAT
---- --------------- --------------- -------- ----------------- --- ---
CATEGORY_N
----------
7777 Feta Frank 777-7777 0 500 400
Classic
8888 Greta Gail 888-8888 4.4 200 400
Classic
9999 Harpo Harry 999-9999 3.3 100 400
Classic
CLIE CLIENT_LNAME CLIENT_FNAME CLIENT_P CLIENT_CREDIT_RTG CLI CAT
---- --------------- --------------- -------- ----------------- --- ---
CATEGORY_N
----------
1111 Alpha Ann 111-1111 4.9 100 500
Family
2222 Beta Bob 222-2222 1.2 200 500
Family
3333 Carlos Ann 333-3333 3.8 300 500
Family
CLIE CLIENT_LNAME CLIENT_FNAME CLIENT_P CLIENT_CREDIT_RTG CLI CAT
---- --------------- --------------- -------- ----------------- --- ---
CATEGORY_N
----------
4444 Delta David 222-2222 3.4 400 500
Family
5555 Beta Edie 555-5555 5 500
Family
6666 Epsilon Emma 666-6666 2.1 400 500
Family
CLIE CLIENT_LNAME CLIENT_FNAME CLIENT_P CLIENT_CREDIT_RTG CLI CAT
---- --------------- --------------- -------- ----------------- --- ---
CATEGORY_N
----------
7777 Feta Frank 777-7777 0 500 500
Family
8888 Greta Gail 888-8888 4.4 200 500
Family
9999 Harpo Harry 999-9999 3.3 100 500
Family
45 rows selected.
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.
VID_ID DATE_DUE
------ ---------
130031 22-SEP-08
130012 22-SEP-08
210011 11-AUG-08
230012 10-SEP-08
220013 25-SEP-08
220062 26-SEP-08
210011 17-SEP-08
7 rows selected.
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.
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.
VID_ID VID_FOR VID_PURCH VID_RENTAL_PRICE MOVIE
------ ------- --------- ---------------- -----
120011 Blu-Ray 11-JAN-04 2.99 10001
130012 DVD 22-FEB-05 4.99 10001
120021 Blu-Ray 03-MAR-03 1.99 10002
130031 DVD 22-FEB-05 4.99 10003
130061 DVD 15-JAN-04 1.99 10006
210011 HD-DVD 05-MAY-03 .99 20001
230012 DVD 01-JAN-04 3.99 20001
330012 DVD 08-MAY-04 3.99 30001
330023 DVD 07-JUN-03 4.99 30002
320031 Blu-Ray 01-DEC-05 2.99 30003
320032 Blu-Ray 01-DEC-05 2.99 30003
VID_ID VID_FOR VID_PURCH VID_RENTAL_PRICE MOVIE
------ ------- --------- ---------------- -----
220032 Blu-Ray 15-JUL-02 1.99 20003
230033 DVD 17-AUG-04 3.99 20003
220042 Blu-Ray 15-JUL-02 1.99 20004
230043 DVD 17-AUG-04 3.99 20004
220051 Blu-Ray 15-JUL-02 1.99 20005
230052 DVD 17-AUG-04 3.99 20005
220061 Blu-Ray 01-DEC-05 2.99 20006
220062 Blu-Ray 01-DEC-05 2.99 20006
220063 Blu-Ray 01-DEC-05 2.99 20006
230064 DVD 01-DEC-05 5.99 20006
420011 Blu-Ray 04-OCT-04 2.19 40001
VID_ID VID_FOR VID_PURCH VID_RENTAL_PRICE MOVIE
------ ------- --------- ---------------- -----
420021 Blu-Ray 04-OCT-04 2.19 40002
420031 Blu-Ray 04-OCT-04 2.19 40003
120041 Blu-Ray 04-OCT-04 1.99 10004
120051 Blu-Ray 04-OCT-04 1.99 10005
26 rows selected.
VID_ID VID_FOR VID_PURCH VID_RENTAL_PRICE MOVIE
------ ------- --------- ---------------- -----
130012 DVD 22-FEB-05 4.99 10001
130022 DVD 04-MAR-06 5.99 10002
130031 DVD 22-FEB-05 4.99 10003
330033 DVD 05-MAY-06 5.99 30003
330034 DVD 05-MAY-06 5.99 30003
230064 DVD 01-DEC-05 5.99 20006
230073 DVD 15-MAR-06 5.99 20007
230074 DVD 15-MAR-06 5.99 20007
8 rows selected.
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.
VID_ID VID_FOR VID_RENTAL_PRICE*.80
------ ------- --------------------
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 VID_RENTAL_PRICE*.80
------ ------- --------------------
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 VID_RENTAL_PRICE*.80
------ ------- --------------------
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.
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.
Num Vids Avg Rental
---------- ----------
42 3.15190476
Enter value for category: 'Classic'
old 4: and category_name = &category
new 4: and category_name = 'Classic'
MOVIE_TITLE
----------------------------------------
Gone with the Wind
It's a Wonderful Life
All About Eve
The Philadelphia Story