It Is time to Pull Data Out of Your Tables
You should have 3 Tables from last week to work with
1) Using your existing tables
a) Create a Simple 2 table inner join
b) Create a 2 table join with an additional WHERE clause
(This WHERE clause is not part of the JOIN)
c) Create a Query that performs a join but returns only 1 useful field from each table joined. By useful here I mean the data is meaningful and makes sense.
2) More Advanced Joins
a) Write a Join that Connects more than 2 tables
b) Write an Outer Join to look for missing data
c) Write a Join that uses both (1: a join that is not an inner join) and (2: a WHERE clause to limit the data returned)