JOINS - Grouping
43.1 - Ex 4

JOINs with GROUP BY - 4

Write an SQL query to display the name of all unique male authors (gender equals M) who have written 3 or more books, with the number of books authored for each of them.

Set the headers for name of authors, and count of books as author and booksAuthored respectively.