some queries for wrangling bigqueries
more bq queries
using the sum(if) approach to count things
tweaking queries