SQL Foundations I Module 3

One query will use a natural join

Only editable by group admins

Last updated November 13, 2017 at 4:52 PM
Evidence visible to public

One query will use a natural join. Submit a link to show your work.

All posted evidence

Results from Task #1 Query #1

jmfisher About 7 years ago

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

/*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;

jmfisher About 7 years ago

One query using natural joins

SQL Fiddle

SQL Fiddle | A tool for easy online testing and sharing of database problems and their solutions.

Application for testing and sharing SQL queries.

mpurnell1 About 7 years ago

SELECT * FROM movies NATURAL JOIN movie_title_ft_index2 WHERE movieid = 50; GROUP BY titleid;

Pastebin

SELECT * FROM movies NATURAL JOIN movie_title_ft_index2 WHERE movieid = 5 - Pastebin.com

vbecu1 About 8 years ago

Uses a NATURAL JOIN to add info for people who aren't dead to the credits table.

Puu

https://puu.sh/sT4EY/2e48c7c42a.png

jaco About 8 years ago

I didn't finish all of them, but I did my best! This is a link to all of them.

Google Docs

MODULE 3 :: TASK 1

Task 1 >> NATURAL JOIN SELECT * FROM Customers NATURAL JOIN Orders; --Task 2 >> INNER JOINS SELECT * FROM Orders INNER JOIN Products USING (ItemNumber); SELECT Orders.OrderNumber, Customers.Address, ItemNumber, ItemDescription, ItemLocation FROM Products INNER JOIN Orders USING (ItemNumber)...