As a hobby, Lee gathers and organizes information on movies, directors, and movie stars. For herreference purpose, she assigns an identification number for a movie existing in the database. Inaddition to this number, she keeps the title of the movie, the type of movie $($comedy$,$ drama, etc.$),$the year it was produced, the rating of MPAA $($Motion Picture Association of America$),$ the numberof Academy Award nominations it received, and the number of Academy Awards it won.Similarly, she assigns an identification number to a new director. She also records the director'sname, the year in which he or she was born, and, if appropriate, the year in which he or she died.Actors and actresses are likewise assigned identification numbers when they are added to thedatabase. Other information for a movie star include the star's name, birthplace, the year born, and,again if appropriate, the year died.The relational schema for the above$-$mentioned application consists of four relations:Movie$($MNumber$,$ Title, Year, Type, Rating, Nomination#$,$ Award#$,$ DNumber$),$Director$($DNumber$,$ Name, YearBorn, YearDied$),$Star$($SNumber$,$ Name, Brithplace, YearBorn, YearDied$),$ andMovieStar$($MNumber$,$ SNumber$).$Specify the following queries in the SQL language:$1.$ List the names $($i$.$e$.,$ Name$)$ and numbers $($i$.$e$.,$ DNumber$)$ of all directors who have directed atleast one comedy$\mathrm{.}2.$ List the movie number $($i$.$e$.,$ MNumber$)$ and title for all movies not directed by Woody Allenthat were nominated for more Academy Awards than all movies directed by Woody Allen$\mathrm{.}3.$ For each director, list the director's number and the total number of awards won by comedies$($movies whose Type is Comedy$)$ he or she has directed.