Query suggestion

[chekos]

Findings regarding RIPA Stop Data Bullet 4

In description add table with

Code	Race/Ethnicity
1	Asian
2	Black/African American
3	Hispanic/Latino
4	Middle Eastern/South Asian
5	Native American
6	Pacific Islander
7	White
8	Multiracial

query

-- Individuals perceived to be Hispanic (39.8%), White (33.2%), or Black (15.2%) comprised the majority of stopped individuals. 
-- 1 Asian, 2 Black/African American, 3 Hispanic/Latino, 4 Middle Eastern/South Asian, 5 Native American, 6 Pacific Islander, 7 White, 8 Multiracial
SELECT
  RAE_FULL,
  COUNT(*) as N,
  PRINTF("%.4f", COUNT(*) * 1.0 / (SELECT COUNT(*) FROM race_ethnicity)) as share
FROM
  race_ethnicity as rae
GROUP BY 
  RAE_FULL