$1.$ Show the movie release countries for all of the movies in the movies table except for the USA.

$2.$ Show the director$$s name, movie title and movie release country for all movies whose release country is NOT the USA. Use the query from #$1$ as a subquery to select all movies with a release country not in the USA.

$3,$ Show the reviewer and the director$$s name for the movies with the highest review ratings in the $1990$s order by the reviewer.

Hint: Subquery is needed.

$4.$ Show the movies that are the only movie in their genre $($In other words, show the movies that are in a genre with only one movie$)$

Hint: Subquery is needed

$5.$ Select the movie title, duration, genre, and average rating for movies that had a run time of $2$ hours and $45$ minutes or more. Order the results in ascending order with the shortest movie at the top.

Hint: Do not use a subquery.

$6.$ What question does this correlated query answer? Begin your answer with "This query answers the question: who are the employees..."

SELECT employee$\_$id$,$ first$\_$name, last$\_$name

FROM employees e

WHERE NOT EXISTS

$($ SELECT $*$

FROM dependents d

WHERE d$.$employee$\_$id $=$ e$.$employee$\_$id$)$

ORDER BY first$\_$name $,$ last$\_$name;

$7.$ What question does this correlated query answer? Begin your answer with "This query answers the question: who are the employees..."

SELECT employee$\_$id$,$ first$\_$name, last$\_$name, salary, department$\_$id

FROM employees e$1$

WHERE salary $>$

$($SELECT AVG$($salary$)$

FROM employees e$2$

WHERE e$1.$department$\_$id $=$ e$2.$department$\_$id

group by department$\_$id$)$;