Assignment 4: Multiple Table SQL Queries
Part 2: Guided discovery for LEFT Join (2 pts)
The following code executes a LEFT JOIN:
SELECT DISTINCT movdir.dirnum, director.lastname, director.firstname
FROM director LEFT JOIN movdir ON director.dirnum = movdir.dirnum
(4 points) List the last and first names of all directors who have directed only one movie.
(10 points) List the movie titles that won both best actor and best actress awards.
