SELECT id, name FROM People WHERE name = "George"; __ ______
Column Table
People INNER JOIN Addresses
People
id name address_id
1 Jim 1
2 John 2
3 Cindy 1
Addresses
id street 1 221 Sugar House Hill Rd 2 3 Center St
(People INNER JOIN Addresses ON People.address_id = Addresses.id)
People.id People.name People.address_id Addresses.street 1 Jim 1 221 Sugar House Hill 2 John 2 3 Cindy 1
1.
SELECT address_id FROM People WHERE name = "Jim";
SELECT street FROM Addresses WHERE id =
2.
SELECT street FROM Addresses WHERE id IN (SELECT address_id FROM People WHERE name = "Jim");
3.
SELECT Addresses.street FROM People INNER JOIN Addresses ON People.address_id = Addresses.id WHERE People.name = "Jim";
=========================================================
https://en.wikibooks.org/wiki/SQL_Exercises