************
problem 3-1
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 3-2
CLIE
----
4444
7777
3333
5555
6666
3333
5555
3333
5555
9999
9999
CLIE
----
1111
3333
13 rows selected.
************
problem 3-3
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 3-4
Avg Cost - Classic # Videos - Classic
------------------ ------------------
3.32333333 6
-*-*-*-*-*-*
using alternate join syntax:
Avg Cost - Classic # Videos - Classic
------------------ ------------------
3.32333333 6
************
problem 3-5
CLIENT_LNAME CLIENT_FNAME DATE_DUE
--------------- --------------- ---------
Beta Bob 08-SEP-08
Carlos Ann 22-SEP-08
Epsilon Emma 16-SEP-08
-*-*-*-*-*-*
using alternate join syntax:
CLIENT_LNAME CLIENT_FNAME DATE_DUE
--------------- --------------- ---------
Beta Bob 08-SEP-08
Carlos Ann 22-SEP-08
Epsilon Emma 16-SEP-08
************
problem 3-6
CLIENT_LNAME CLIENT_FNAME
--------------- ---------------
Beta Bob
Carlos Ann
Epsilon Emma
************
problem 3-7
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
-*-*-*-*-*-*
using alternate join syntax:
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 3-8
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 3-9
CLIENT_LNAME CLIENT_P CLIENT_CREDIT_RTG
--------------- -------- -----------------
Beta 222-2222 1.2
Carlos 333-3333 3.8
Greta 888-8888 4.4
Beta 555-5555 5
Alpha 111-1111 4.9
Epsilon 666-6666 2.1
6 rows selected.
************
problem 3-10
CLIENT_LNAME CLIENT_P CLIENT_CREDIT_RTG
--------------- -------- -----------------
Alpha 111-1111 4.9
Carlos 333-3333 3.8
Epsilon 666-6666 2.1
Beta 222-2222 1.2
Beta 555-5555 5
Greta 888-8888 4.4
6 rows selected.
-*-*-*-*-*-*
using alternate join syntax:
CLIENT_LNAME CLIENT_P CLIENT_CREDIT_RTG
--------------- -------- -----------------
Alpha 111-1111 4.9
Carlos 333-3333 3.8
Epsilon 666-6666 2.1
Beta 222-2222 1.2
Beta 555-5555 5
Greta 888-8888 4.4
6 rows selected.
-*-*-*-*-*-*
using alternate nested syntax (without using exists):
CLIENT_LNAME CLIENT_P CLIENT_CREDIT_RTG
--------------- -------- -----------------
Beta 222-2222 1.2
Carlos 333-3333 3.8
Greta 888-8888 4.4
Beta 555-5555 5
Alpha 111-1111 4.9
Epsilon 666-6666 2.1
6 rows selected.
************
problem 3-11
# never rented their avg rental price
-------------- ----------------------
28 3.10071429