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

Show different publishers together with the number of publications they have Plot them as bar chart, show by the y axis from low to high.
SELECT Publisher, COUNT(*) FROM publication GROUP BY Publisher ORDER BY COUNT(*)
SELECT "Publisher", COUNT(*) FROM "publication" GROUP BY "Publisher" ORDER BY COUNT(*)