Write the SQL queries of each of the following using SQL languages and show the result from the image of tables below.

$$ A$.$ For every project located in 'Stafford', list the project number, the controlling department number, and the department manager's last name, address, and birth date.

$$ B$.$ Retrieve the information of the 'administration' manager.

$$ C$.$ Retrieve names of all employees whose address is in Houston, Texas.

$------$Part $2------$

Consider a MOVIE database in which data is recorded about the movie industry. The data requirements are summarized as follows:

$$ Each movie is identified by title and year of release. Each movie has a length in minutes. Each has a production company, and each is classified under one or more genres $($such as horror, action, drama, and so forth$).$ Each movie has one or more directors, and one or more actors appear in it$.$ Each movie also has a plot outline.Finally, each movie has zero or more quotable quotes, each of which is spoken by a particular actor appearing in the movie.

$$ Actors are identified by name and date of birth and appear in one or more movies. Each actor has a role in the movie.

$$ Directors are also identified by name and date of birth and direct one or more movies. It is possible for a director to act in a movie $($including one that he or she may also direct$).$

$$ Production companies are identified by name, and each has an address. A production company produces one or more movies.Draw an entity$-$relationship diagram $($ER$)$ for the movie database $($use one of the existing online modeling tools$).$