What is the proportion of white males and females in the police force?
white refers to race = 'W'; male refers to gender = 'M'; female refers to gender = 'F'; proportion of white males = divide(count(officers where race = 'W' and gender = 'M'), count(officers)) * 100%; proportion of white females = divide(count(officers where race = 'W' and gender = 'F'), count(officers)) * 100%
SELECT CAST(SUM(gender = 'M') AS REAL) / SUM(gender = 'F') FROM officers WHERE race = 'W'
database name:db_id shooting
Incidents table Incidents Cols: case number dtype text, date dtype date, location dtype text, subject statuses dtype text, subject weapon dtype text, subjects dtype text, subject_count dtype integer, officers dtype text, 
officers table officers Cols: case number dtype text, race dtype text, gender dtype text, last name dtype text, first name dtype text, full name dtype text, 
subjects table subjects Cols: case number dtype text, race dtype text, gender dtype text, last name dtype text, first name dtype text, full name dtype text, 
