Question
a. Create a view that lists all plays in alphabetical order and names of the directors. Play Director Cat Goofy Hold Hollywoody ... ... b.
a.Create a view that lists all plays in alphabetical order and names of the directors. Play Director Cat Goofy Hold Hollywoody ... ...
b.Find all directors who were born between January 1st, 1962 and December 31st, 1962. Provide SQL code and the result.
c.Delete director with number 101 from directors table. Provide SQL code and the result of select statement for both tables before deletion and after deletion.
d.Update table PLAY. Change the name of play #1006 to Starbuck in Biloxi.
e.Find all directors who directed less than two plays. Provide SQL code and the result.
Table name: Director
DIR_NUM DIR_LNAME DIR_DOB
100 Broadway 12-Jan-65
101 Hollywoody 18-Nov-53
102 Goofy 21-Nov-62
Table name: PLAY
PLAY_CODE PLAY_NAME DIR_NUM
1000 cat 102
1001 Hold 101
1003 I never 102
1004 Sily 100
1005 See 101
1006 Star 102
1007 Stranger 101
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started