link for more detail on database below:

http://sqlzoo.net/wiki/More_JOIN_operations

Data Sciences SQL Test 1. You will have 2 hours to complete this test. At the end of the 2 hours, please send all your code to hiring@datasciences.ca either in a text file or in the email directly. It is not necessary to submit the results of your code, just your code. 2. If you do not complete the test, please submit whatever you have at the 2hr mark. Submit all code written arnd any pseudo-code that you have for the remaining questions. 3. If you do not submit within the allotted time, your test wil not get marked. 4. The database you will be using contains the following 3 tables: Movie title director budget gross Actor e name Casting TOwieid actorid ord Movie- is a list of all movies in the database Actor is a list of all actors/actesses in the database Casting- allows you to link the movies to the actors in them. The ord field gives the position of the actor so Ord-1 for lead actors More details about the datahase can be found by going to: and clicking on the More details about the database link. Please write SQL queries to answer the following questions: 1 List all movies that have a title that starts with 'Cat, with year in date order 2. What are the top 5 grossing movies in the database? What year did they come out and who were the lead actors? Please write SQL queries to answer the following questions: 1. List all movies that have a title that starts with Cat', with year in date order 2. What are the top 5 grossing movies in the database? What year did they come out and who were the lead actors? In what years did Glenn Close make more than 1 movie? How many movies did she make in each of those years? And what was the total gross revenue of her movies in those years? 3. 4. Which director has the most movies that came ahead of budget (gross> budget)? 5. Who is Director Steven Spielberg's favourite actor, i.e., which actor has appeared in the most films of Steven Spielberg's