Skip to content

Instantly share code, notes, and snippets.

@clue

clue/hello.sql

Last active January 26, 2022 10:34
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save clue/aa617c594bb25247b523ae4b471c6099 to your computer and use it in GitHub Desktop.
Save clue/aa617c594bb25247b523ae4b471c6099 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
hello.sql
SELECT
users.name,
groups.name AS `group`
FROM
URL('https://gist.github.com/clue/dde9700e9be30db2abd3c763833aa631/raw/962e5d6a337a9bf14e1816f548ea996358c235f8/users.json') AS users,
URL('https://gist.github.com/clue/dde9700e9be30db2abd3c763833aa631/raw/962e5d6a337a9bf14e1816f548ea996358c235f8/groups.json') AS groups
WHERE users.`group` = groups.id
ORDER BY `group` DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment