Skip to content

Instantly share code, notes, and snippets.

@adrimolano

adrimolano/exercise 10_sql

Created May 9, 2016 22:18
Show Gist options
  • Save adrimolano/231ad62d1a0412608310bd7056e4470e to your computer and use it in GitHub Desktop.
Save adrimolano/231ad62d1a0412608310bd7056e4470e to your computer and use it in GitHub Desktop.
Download ZIP
exercise 10_sql
Raw
exercise 10_sql
SELECT count(editions.isbn) AS "number of books", authors.id, concat_ws (',',authors.first_name , authors.last_name) AS "full name"
FROM editions
join books on editions.book_id = books.id
join authors on books.author_id = authors.id
group by authors.id;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment