chekos/RIPA-2018-datasette

Query suggestion

Opened this issue · 0 comments

chekos commented

Fixing Race/Ethnicity Numbers by Agency Name

query

SELECT
  b.AGENCY_NAME as agency_name,
  rae.RAE_FULL as race_ethnicity,
  COUNT(rae.RAE_FULL) as N
FROM
  race_ethnicity as rae
  INNER JOIN aa_main_table as b ON b.UNIQUE_ID = rae.UNIQUE_ID
GROUP BY
  agency_name,
  rae.RAE_FULL