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)

A bar chart for listing the number of the writers of the books in ascending alphabetical order.
SELECT Writer, COUNT(Writer) FROM book GROUP BY Writer ORDER BY Writer
SELECT "Writer", COUNT("Writer") FROM "book" GROUP BY "Writer" ORDER BY "Writer"