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

Show different publishers together with the number of publications they have Plot them as bar chart, and could you list by the total number from high to low?
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