Question: Write the following questions as queries in SQL. Use only the operators discussed in class (in particular, no outer joins or windows). Again, type

Write the following questions as queries in SQL. Use only the operators discussed in class (in particular, no

Write the following questions as queries in SQL. Use only the operators discussed in class (in particular, no outer joins or windows). Again, type your answers. Before starting, make sure you understand the schema of the database. If you are in doubt about it, please ask the instructor. Assume a database with schema ACTOR(name,age,address,nationality) MOVIE (title,year,genre,budget,director-name,studio) APPEARS(name,title,salary) Write the following questions in SQL: 1. List the titles and budgets of movies where actor Keanu Reeves appeared in 1999. 2. List the names and ages of actors who have appeared in a comedy produced by Studio 'MGM'. 3. List the names of directors who have directed a drama or a comedy. 4. List the names of directors who have directed a drama and a comedy. 5. List pairs of actors who have appeared together in a movie (note: the schema of your answer should be (name1,name2), where both name1 and name2 are names of actors.

Step by Step Solution

3.27 Rating (150 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Here are SQL queries for the given questions 1 List the titles and budgets of movies where actor Kea... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!