Database schema

Database schema

SQL query to do

Please provide data about the number of books published for each year. Data must be displayed in descending order by the number of published books. Required attributes are Publication_year and the number of published books, which have to be renamed into Year and NbOfBooks.

{{flash_text1}}