Please add a google-bigquery tag (see tag info on SO). DBA.SE questions that would be covered by this tag include: Aggregating two queries and returning a COUNT of some permutations Alternatives for storing 365TB of info Counting unique records across 2 columns and computing a score based on bo...