************
problem 2
MOVIE
-----
10001
10002
10003
30001
30002
30003
6 rows selected.
************
problem 3
MOVIE_TITLE
----------------------------------------
Babe
Gone with the Wind
It's a Wonderful Life
The Muppet Movie
Toy Story
Toy Story 2
6 rows selected.
************
problem 4
MOVIE_TITLE
----------------------------------------
All About Eve
Babe
Clockwork Orange
Fatal Attraction
Indiana Jones and the Last Crusade
Midnight Cowboy
Return of the Jedi
The Blues Brothers
The Matrix
The Philadelphia Story
10 rows selected.
************
problem 5
VID_ID VID_RENTAL_PRICE
------ ----------------
230064 5.99
230073 5.99
230074 5.99
330033 5.99
330034 5.99
230043 3.99
230052 3.99
330012 3.99
220061 2.99
220063 2.99
220071 2.99
VID_ID VID_RENTAL_PRICE
------ ----------------
220072 2.99
320031 2.99
220021 2.19
420021 2.19
420031 2.19
420042 2.19
120021 1.99
120041 1.99
120051 1.99
130061 1.99
220032 1.99
VID_ID VID_RENTAL_PRICE
------ ----------------
220042 1.99
220051 1.99
320011 1.99
320021 1.99
320022 1.99
210041 1.29
410041 1.29
210011 .99
210031 .99
31 rows selected.
************
problem 6
CLIE
----
4444
9999
************
problem 7
VID_ID MOVIE_TITLE VID_FOR NUM_RENTALS
------ ---------------------------------------- ------- -----------
120041 All About Eve Blu-Ray 0
320011 Babe Blu-Ray 0
330012 Babe DVD 0
420031 Clockwork Orange Blu-Ray 0
420042 Fatal Attraction Blu-Ray 0
410041 Fatal Attraction HD-DVD 0
120011 Gone with the Wind Blu-Ray 4
130012 Gone with the Wind DVD 3
220021 Indiana Jones and the Last Crusade Blu-Ray 0
220013 Indiana Jones and the Temple of Doom Blu-Ray 1
230012 Indiana Jones and the Temple of Doom DVD 1
VID_ID MOVIE_TITLE VID_FOR NUM_RENTALS
------ ---------------------------------------- ------- -----------
210011 Indiana Jones and the Temple of Doom HD-DVD 2
120021 It's a Wonderful Life Blu-Ray 0
130022 It's a Wonderful Life DVD 1
420021 Midnight Cowboy Blu-Ray 0
420011 One Flew Over the Cuckoo's Nest Blu-Ray 1
220051 Return of the Jedi Blu-Ray 0
230052 Return of the Jedi DVD 0
220032 Star Wars Blu-Ray 0
230033 Star Wars DVD 1
210031 Star Wars HD-DVD 2
130061 The Blues Brothers DVD 0
VID_ID MOVIE_TITLE VID_FOR NUM_RENTALS
------ ---------------------------------------- ------- -----------
220042 The Empire Strikes Back Blu-Ray 0
230043 The Empire Strikes Back DVD 0
210041 The Empire Strikes Back HD-DVD 1
220071 The Matrix Blu-Ray 0
220072 The Matrix Blu-Ray 0
230073 The Matrix DVD 0
230074 The Matrix DVD 0
130031 The Muppet Movie DVD 3
220061 The Phantom Menace Blu-Ray 0
220062 The Phantom Menace Blu-Ray 1
220063 The Phantom Menace Blu-Ray 0
VID_ID MOVIE_TITLE VID_FOR NUM_RENTALS
------ ---------------------------------------- ------- -----------
230064 The Phantom Menace DVD 0
120051 The Philadelphia Story Blu-Ray 0
320021 Toy Story Blu-Ray 0
320022 Toy Story Blu-Ray 0
330023 Toy Story DVD 1
320031 Toy Story 2 Blu-Ray 0
320032 Toy Story 2 Blu-Ray 1
330033 Toy Story 2 DVD 0
330034 Toy Story 2 DVD 0
42 rows selected.
************
problem 8
CLIENT_LNAME CLIENT_CREDIT_RTG
--------------- -----------------
Alpha 4.9
Beta 1.2
Carlos 3.8
Delta 3.4
Beta 5
Epsilon 2.1
Feta 0
Greta 4.4
Harpo 3.3
9 rows selected.
1 row updated.
CLIENT_LNAME CLIENT_CREDIT_RTG
--------------- -----------------
Alpha 4.9
Beta 1.2
Carlos 3.8
Delta 3.8
Beta 5
Epsilon 2.1
Feta 0
Greta 4.4
Harpo 3.3
9 rows selected.
************
problem 9
VID_ID VID_RENTAL_PRICE
------ ----------------
120011 2.99
120021 1.99
210011 .99
220013 2.19
220021 2.19
320011 1.99
320021 1.99
320022 1.99
320031 2.99
320032 2.99
210031 .99
VID_ID VID_RENTAL_PRICE
------ ----------------
220032 1.99
210041 1.29
220042 1.99
220051 1.99
220061 2.99
220062 2.99
220063 2.99
420011 2.19
420021 2.19
420031 2.19
120041 1.99
VID_ID VID_RENTAL_PRICE
------ ----------------
120051 1.99
410041 1.29
420042 2.19
220071 2.99
220072 2.99
27 rows selected.
27 rows updated.
VID_ID VID_RENTAL_PRICE
------ ----------------
120011 2.45
120021 1.63
210011 .81
220013 1.8
220021 1.8
320011 1.63
320021 1.63
320022 1.63
320031 2.45
320032 2.45
210031 .81
VID_ID VID_RENTAL_PRICE
------ ----------------
220032 1.63
210041 1.06
220042 1.63
220051 1.63
220061 2.45
220062 2.45
220063 2.45
420011 1.8
420021 1.8
420031 1.8
120041 1.63
VID_ID VID_RENTAL_PRICE
------ ----------------
120051 1.63
410041 1.06
420042 1.8
220071 2.45
220072 2.45
27 rows selected.
************
problem 10
RENTAL_ CLIE VID_ID DATE_OUT DATE_DUE DATE_RETU
------- ---- ------ --------- --------- ---------
0000018 1111 220062 21-SEP-08 26-SEP-08
0000008 1111 130022 04-SEP-07 07-SEP-08 14-SEP-08
0000016 2222 330023 11-SEP-08 16-SEP-08 15-SEP-08
0000002 2222 130031 19-SEP-08 22-SEP-08
0000003 2222 130012 03-SEP-08 08-SEP-08 04-SEP-08
0000007 3333 120011 15-SEP-08 18-SEP-08 21-SEP-08
0000015 3333 420011 01-SEP-08 04-SEP-08 03-SEP-08
0000004 3333 130012 21-SEP-08 22-SEP-08
0000019 3333 320032 06-SEP-08 09-SEP-08 07-SEP-08
0000005 3333 210011 08-AUG-08 11-AUG-08
0000023 4444 120011 16-SEP-08 18-SEP-08 21-SEP-08
RENTAL_ CLIE VID_ID DATE_OUT DATE_DUE DATE_RETU
------- ---- ------ --------- --------- ---------
0000022 5555 210031 16-SEP-08 18-SEP-08 17-SEP-08
0000001 5555 120011 21-SEP-08 23-SEP-08 22-SEP-08
0000017 5555 220013 22-SEP-08 25-SEP-08
0000009 6666 130012 13-SEP-08 16-SEP-08 16-SEP-08
0000021 6666 210011 15-SEP-08 17-SEP-08
0000020 7777 130031 29-AUG-08 01-SEP-08 02-SEP-08
0000024 7777 130031 08-SEP-08 10-SEP-08 09-SEP-08
0000010 7777 120011 14-SEP-08 17-SEP-08 17-SEP-08
0000011 8888 230012 05-SEP-08 10-SEP-08
0000012 9999 210031 10-SEP-08 13-SEP-08 13-SEP-08
0000014 9999 230033 10-SEP-08 13-SEP-08 13-SEP-08
RENTAL_ CLIE VID_ID DATE_OUT DATE_DUE DATE_RETU
------- ---- ------ --------- --------- ---------
0000013 9999 210041 10-SEP-08 13-SEP-08 13-SEP-08
23 rows selected.
5 rows deleted.
RENTAL_ CLIE VID_ID DATE_OUT DATE_DUE DATE_RETU
------- ---- ------ --------- --------- ---------
0000018 1111 220062 21-SEP-08 26-SEP-08
0000008 1111 130022 04-SEP-07 07-SEP-08 14-SEP-08
0000002 2222 130031 19-SEP-08 22-SEP-08
0000003 2222 130012 03-SEP-08 08-SEP-08 04-SEP-08
0000016 2222 330023 11-SEP-08 16-SEP-08 15-SEP-08
0000023 4444 120011 16-SEP-08 18-SEP-08 21-SEP-08
0000017 5555 220013 22-SEP-08 25-SEP-08
0000022 5555 210031 16-SEP-08 18-SEP-08 17-SEP-08
0000001 5555 120011 21-SEP-08 23-SEP-08 22-SEP-08
0000009 6666 130012 13-SEP-08 16-SEP-08 16-SEP-08
0000021 6666 210011 15-SEP-08 17-SEP-08
RENTAL_ CLIE VID_ID DATE_OUT DATE_DUE DATE_RETU
------- ---- ------ --------- --------- ---------
0000024 7777 130031 08-SEP-08 10-SEP-08 09-SEP-08
0000010 7777 120011 14-SEP-08 17-SEP-08 17-SEP-08
0000020 7777 130031 29-AUG-08 01-SEP-08 02-SEP-08
0000011 8888 230012 05-SEP-08 10-SEP-08
0000014 9999 230033 10-SEP-08 13-SEP-08 13-SEP-08
0000013 9999 210041 10-SEP-08 13-SEP-08 13-SEP-08
0000012 9999 210031 10-SEP-08 13-SEP-08 13-SEP-08
18 rows selected.
************
problem 11
current # videos
----------------
42
30 rows deleted.
VID_ID VID_FOR VID_PURCH VID_RENTAL_PRICE MOVIE
------ ------- --------- ---------------- -----
120011 Blu-Ray 11-JAN-04 2.45 10001
130012 DVD 22-FEB-05 4.99 10001
130022 DVD 04-MAR-06 5.99 10002
130031 DVD 22-FEB-05 4.99 10003
210011 HD-DVD 05-MAY-03 .81 20001
210031 HD-DVD 05-MAY-02 .81 20003
210041 HD-DVD 05-MAY-02 1.06 20004
220013 Blu-Ray 05-APR-02 1.8 20001
220062 Blu-Ray 01-DEC-05 2.45 20006
230012 DVD 01-JAN-04 3.99 20001
230033 DVD 17-AUG-04 3.99 20003
VID_ID VID_FOR VID_PURCH VID_RENTAL_PRICE MOVIE
------ ------- --------- ---------------- -----
330023 DVD 07-JUN-03 4.99 30002
12 rows selected.
************
problem 12
(note: your table will be different, of course...)
Table dropped.
Table created.
************
problem 13
(...and you choose where *your* sequence starts...)
Sequence dropped.
Sequence created.
************
problem 14
(...and you will have different rows in your different table...)
1 row created.
1 row created.
1 row created.
BOOK_NUM BOOK_TITLE BOOK_CATEGO BOOK_QUANTITY
---------- ------------------------------- ----------- -------------
1001 Little Women Fiction 10
1002 Good Eats Cooking 1
1003 Madame Curie Non-Fiction 7