Database schema

Database schema

SQL query to do

Please provide data about all authors and the number of books in which each has been involved in the drafting. Required attributes are last name, first name and the number of books, which have to be renamed into LastName, FirstName and NbOfBooks.

{{flash_text1}}