How to count for each row using other table in SQL? : <p>I have two tables: book table and author table. I need to count for each author how many book is registered in book table. How to do that?</p>
