-- Database schema
| incidents : case_number [ TEXT ] primary_key , date [ DATE ] , location [ TEXT ] , subject_statuses [ TEXT ] , subject_weapon [ TEXT ] , subjects [ TEXT ] , subject_count [ INTEGER ] , officers [ TEXT ] | officers : case_number [ TEXT ] officers.case_number = incidents.case_number , race [ TEXT ] , gender [ TEXT ] , last_name [ TEXT ] , first_name [ TEXT ] , full_name [ TEXT ] | subjects : case_number [ TEXT ] subjects.case_number = incidents.case_number , race [ TEXT ] , gender [ TEXT ] , last_name [ TEXT ] , first_name [ TEXT ] , full_name [ TEXT ] |
-- -- What is the proportion of white males and females in the police force?

SELECT CAST(SUM(gender = 'M') AS REAL) / SUM(gender = 'F') FROM officers WHERE race = 'W';