forgot to aggregate on some of these queries

fixes #49