Assignment 4: Multiple Table SQL Queries

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.