On Oct 26, 11:06 am, herbasher <rob...@gmail.com> wrote:
> Hello!
>
> I have three tables, mapping out a n:n relationship of authors and the
> books they worked on:
>
> table 1: authors (id, name)
> table 2: authorships (author_id, book_id)
> table 3: books (id, name, bestseller tinyint)
>
> Here's two different queries I want to run:
>
> 1. Select each author, and how many books he has worked on.
> 2. Select each author, and how many bestseller books (bestseller = 1)
> he has worked on.
>
> Not exactly sure how to do this, can someone help me out with this?

Is this hard? Possible? Expensive?


Thanks