How to select the first N rows of each group?
I have two SQLite tables like this:
AuthorId | AuthorName
----------------------
1 | Alice
2 | Bob
3 | Carol
... | ....
BookId | AuthorId | Title
-----------------...
stackoverflow.com