Following picture is the query form # 2 Show the director's name, movie title and movie release

 Following picture is the query form # 2

 

Transcribed Image Text:

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 #2 as a subquery to select all movies with a release country not in the USA. dir_firstName John Danny Danny James James James Michael Jack Frank Milos Mel Alfred Richard Stanley dir_lastName Boorman Boyle Boyle Cameron Cameron Cameron Cimino Clayton Darabont Forman Gibson Hitchcock Kelly Kubrick mov_title Deliverance Trainspotting Slumdog Millionaire Titanic Aliens Avatar mov_rel_country UK UK UK UK UK UK Amadeus Seven Samurai Vertigo Donnie Darko Eyes Wide Shut The Deer Hunter The Innocents The Shawshank Re... UK ********* 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 #2 as a subquery to select all movies with a release country not in the USA. dir_firstName John Danny Danny James James James Michael Jack Frank Milos Mel Alfred Richard Stanley dir_lastName Boorman Boyle Boyle Cameron Cameron Cameron Cimino Clayton Darabont Forman Gibson Hitchcock Kelly Kubrick mov_title Deliverance Trainspotting Slumdog Millionaire Titanic Aliens Avatar mov_rel_country UK UK UK UK UK UK Amadeus Seven Samurai Vertigo Donnie Darko Eyes Wide Shut The Deer Hunter The Innocents The Shawshank Re... UK *********

Answer rating: 100% (QA)

It looks like the task is to write a SQL query that selects the directors name movie title and movie ... View the full answer