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 1^st, 1962 and December 31^st, 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