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

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