Pretty much done, but none have been tested.

When test data comes out, we can fix these up. This is the greater part of the queries for this project.