Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Query suggestion #21

Open
chekos opened this issue May 4, 2020 · 0 comments
Open

Query suggestion #21

chekos opened this issue May 4, 2020 · 0 comments
Assignees
@chekos
Labels
suggestion A canned query suggestion (to be included by default in future deployment)

Comments

@chekos
Copy link
Owner

chekos commented May 4, 2020

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
@chekos chekos added the suggestion A canned query suggestion (to be included by default in future deployment) label May 4, 2020
@chekos chekos self-assigned this May 4, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@chekos chekos

Labels
suggestion A canned query suggestion (to be included by default in future deployment)
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@chekos