Skip to content

Instantly share code, notes, and snippets.

@dgershman

dgershman/tomato_common_names.sql

Created January 6, 2019 15:04
Show Gist options
  • Save dgershman/5aa65eed63e236e7faea8f89be91da61 to your computer and use it in GitHub Desktop.
Save dgershman/5aa65eed63e236e7faea8f89be91da61 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
tomato_common_names.sql
SELECT
TRIM(REPLACE(UPPER(name), 'GROUP', '')))
count(TRIM(REPLACE(UPPER(name), 'GROUP', ''))))
FROM api_meetings
GROUP BY TRIM(REPLACE(UPPER(name), 'GROUP', '')))
ORDER BY TRIM(REPLACE(UPPER(name), 'GROUP', ''))) DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment