Problem
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:
A. List the titles and budgets of movies where actor Keanu Reeves appeared in 1999.
B. List the names and ages of actors who have appeared in a comedy produced by Studio 'MGM'.
C. List the names of directors who have directed a drama or a comedy.
D. List the names of directors who have directed a drama and a comedy.
E. 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.