Another look at LOGICAL_AND & LOGICAL_OR in BigQuery

Out of all those non-standard SQL functions in BigQuery, I think I like LOGICAL_AND and LOGICAL_OR the most. These are aggregation functions I've posted about before (link in my comments), but just wanted to showcase how versatile they can be. So...