Hello.
I'd like to know the SQL query for the following operation.
Table
AUTHOR BOOK
Bill A
Bill B
Charles A
Bill C
....
Output
Bill : 3 books
Charles : 1 book
I know that there is a function to get the number of matching field but
in this case I don't know what authors are in this table. Maybe I
should,
1)Get each unique authors
2)Query the number of matching items using author's name.
I don't know how to do the 1 and is there any better way? Thank you.