SQL

List all zip codes along with a column that classifies their gender distribution in 2018. To calculate the distribution, take the female population and divide by the total population. Then, for the classification, if the % female is greater than 60%, call it "predominantly female". If it is below 40%, call it "predominantly male." For everything else, input "evenly distributed". (As a hint, include a new field that calculates the gender distribution, and then use that field in your CASE statement.) In the results, include the zip code, gender distribution (%), and the gender distribution classification. Finally, only include zip codes with a total population of at least 1000 people and sort by the zip code in ascending order.

Based on the query results, what percentage of the population was female in 2018?

FROM CENSUS_BY_ZIP_CODE

ZIP_CODE VARCHAR (5) NOT NULL, REPORTING_YEAR NUMBER (38,), HOUSEHOLDS NUMBER (38,0), POPULATION_TOTAL NUMBER (38,0), POPULATION_MALE NUMBER (38,0), POPULATION_FEMALE NUMBER (38,0), MEDIAN_AGE NUMBER (3,1), HOUSING_UNITS_TOTAL NUMBER(38,0), HOUSING_UNITS_OCCUPIED NUMBER (38,0)