Skip to content

Query suggestion #28

@chekos

Description

@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

Metadata

Metadata

Assignees

Labels

suggestionA canned query suggestion (to be included by default in future deployment)

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions