Assignment: Multiple Table SQL Queries
Guided discovery for LEFT Join
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
List the last and first names of all directors who have directed only one movie.
List the movie titles that won both best actor and best actress awards.