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 I want to order by the bars in asc.
SELECT Publisher, COUNT(*) FROM publication GROUP BY Publisher ORDER BY Publisher
SELECT "Publisher", COUNT(*) FROM "publication" GROUP BY "Publisher" ORDER BY "Publisher" NULLS FIRST