added email column for emails apparently. changed nested aggregate query
to reflect reqs