Added new data
Fixed date entry
Figured out how to use an alias AS on FULL JOINs
Consolidated master query with better headers
Question 1 works
Using main table to fulfill questions, 2 & 3 done
Realized duping due to structure, using DISTINCT now

fixed problem 2 as well
used DISTINCT ON to complete question5
Completed!

Google helps
FINAL PROOF