forgot to aggregate on some of these queries

fixes #49
fix up some of the reports