Query suggestion

[chekos]

firearm point and discharge stats by racen

query

select
  rae_codes.RACE_ETHNICITY,
  sum(ADS_FIREARM_POINT),
  sum(ADS_FIREARM_DISCHARGE)
from
  action_taken as at
  inner join race_ethnicity as rae on rae.UNIQUE_ID = at.UNIQUE_ID
  inner join race_ethnicity_codes as rae_codes on rae.RAE_FULL = rae_codes.CODE
group by
  rae.RAE_FULL