How to compose SQL query with COUNT?

Question

MySQL

There are 2 tables in the database: authors and docs with fields (id, name) and (id, title, author).
How to make a query that would display the fields: author - the number of his documents?
if the document does not have an author, then display the number of such documents
Something like:
Vasya 15
Petya 10
Lena 0
null 50

Answer 1

select au.name, count(docs.id)
from docs 
left join  authors au on au.id = docs.author
group by au.name