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

Understanding BigQuery's any_value Function for Advanced Data Analysis