Of all male officers, what percentage are black officers?
male refers to gender = 'M'; black refers to race = 'B'; percentage = divide(count(officers where race = 'B'), count(officers)) where gender = 'M' * 100%
SELECT CAST(SUM(race = 'B') AS REAL) * 100 / COUNT(case_number) FROM officers WHERE gender = 'M'
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, 
