Using COUNTIF() in BigQuery

Happy weekend! Do you remember the good old COUNTIF from Excel?When I was just starting out in Analytics and was working with spreadsheets, I would make heavy use of it. Well, turns out we have something similar in BigQuery as well. It's an aggregate...