Jay Fisher

One query will use a natural join

Used Kongora Movies Database as I didn't think my personal project data would lend itself well to a NATURAL join

• November 14, 2017 at 10:46 AM
• Last updated about 7 years ago
• Visible to public

/*Task 1*/
/*Query 1 - Show all credited US movies for those born in 1978*/
SELECT first_name, surname, UPPER(title), year_released FROM credits
NATURAL JOIN people
NATURAL JOIN movies
WHERE (born = 1978) & (country = 'us')
ORDER BY surname;