Answer Happy

In this phase you will demonstrate your knowledge of selecting
data from multiple tables. Each query must return the data in
the order shown in the question and produce the correct results
All these queries will require you to join on at least three
tables. Be sure to identify the table where the data is
stored and then figure out how to join all the tables
together. Remember for three tables you will need a minimum
of two joins.
NOTE: Any reference to full name in any of the queries means to
return the first name middle initial (if any) and last name as one
column.