Consider a database containing information related to movies organized in tables corresponding to the following relations(sample create table...

Consider a database containing information related to movies organized in tables corresponding to the following relations(sample create table statements in the Appendix):

Movie(title, year, genre, budget, gross)

Director(name, country, YofB)

Actor(name, country, YofB)

Producer(name, country, YofB)

DirectorMovie(d_name, m_title, m_year)

ActorMovie(a_name, m_title, m_year)

ProducerMovie(p_name, m_title, m_year)

Write the following queries in SQL:

1.Find directors who were younger than all the actors they directed in a movie

2.List all producers in the order of their average profit (the profit for each movie is calculated as the difference between its gross earnings and its budget).

3.List all directors who were very prolific in their first 5 years of activity, i.e., they directed at least one movie each year, in the first 5 years after their first movie (counting the year of their first movie as the first of 5.)