Getting the Lowest Value Per Column Based on Another Column with Window Functions

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