CREATE TABLE book (Book_ID INT, Title TEXT, Issues FLOAT, Writer TEXT)
CREATE TABLE publication (Publication_ID INT, Book_ID INT, Publisher TEXT, Publication_Date TEXT, Price FLOAT)

Draw a bar chart of publisher versus the total number, and list in descending by the the total number .
SELECT Publisher, COUNT(*) FROM publication GROUP BY Publisher ORDER BY COUNT(*) DESC
SELECT "Publisher", COUNT(*) FROM "publication" GROUP BY "Publisher" ORDER BY COUNT(*) DESC NULLS LAST