Using COUNT() Window Function to Identify Male and Female Groups in Google Big Query

Converting Array-of-Strings to Array-of-Type in BigQuery: A Practical Guide to Workarounds and Solutions