Skip to content

Instantly share code, notes, and snippets.

@wertklop

wertklop/query.sql Secret

Last active October 17, 2018 18:55
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 wertklop/fa828201e30cd3c7b794bb5c86164de6 to your computer and use it in GitHub Desktop.
Save wertklop/fa828201e30cd3c7b794bb5c86164de6 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
query.sql
SELECT DISTINCT author FROM books WHERE author NOT in(SELECT max(author) FROM books GROUP BY book HAVING count(author) = 1);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment