Homework 5
<your name should appear here>
===== Problem 2 =====
AVG(VID_RENTAL_PRICE)
---------------------
3.15190476
===== Problem 3 =====
VID_ID
------
120011
120021
130061
210011
220013
220021
320011
320021
320022
320031
320032
VID_ID
------
210031
220032
210041
220042
220051
220061
220062
220063
420011
420021
420031
VID_ID
------
120041
120051
410041
420042
220071
220072
28 rows selected.
===== Problem 4 =====
CLIE
----
5555
3333
3333
7777
9999
9999
3333
5555
1111
3333
6666
CLIE
----
5555
4444
13 rows selected.
===== Problem 5 =====
CLIENT_LNAME CLIENT_CREDIT_RTG
--------------- -----------------
Alpha 4.9
Carlos 3.8
Delta 3.4
Beta 5
Epsilon 2.1
Feta 0
Harpo 3.3
7 rows selected.
===== Problem 6 =====
Avg Cost - Classic # Videos - Classic
------------------ ------------------
3.32333333 6
===== Problem 7 =====
CLIENT_LNAME CLIENT_FNAME DATE_DUE
--------------- --------------- ---------
Beta Bob 08-SEP-16
Carlos Ann 22-SEP-16
Epsilon Emma 16-SEP-16
===== Problem 8 =====
CLIENT_LNAME CLIENT_FNAME
--------------- ---------------
Beta Bob
Carlos Ann
Epsilon Emma
===== Problem 9 =====
CLIENT_LNAME CATEGORY_N CLIENT_CREDIT_RTG
--------------- ---------- -----------------
Alpha Comedy 4.9
Carlos Drama 3.8
Delta Classic 3.4
Greta Action 4.4
Harpo Comedy 3.3
===== Problem 10 =====
Enter value for dir_lname: Lasseter
old 4: '&dir_lname'
new 4: 'Lasseter'
MOVIE_TITLE
----------------------------------------
Toy Story
Toy Story 2
===== Problem 11 =====
Enter value for category: Classic
old 5: '&category'
new 5: 'Classic'
MOVIE_TITLE
----------------------------------------
Gone with the Wind
It's a Wonderful Life
All About Eve
The Philadelphia Story