SQL Queries

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 

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.  
Powered by