text: CREATE TABLE publication (Publisher VARCHAR) -- Show publishers that have more than one publication. SELECT Publisher FROM publication GROUP BY Publisher HAVING COUNT(*) > 1 CREATE TABLE publication (Publisher VARCHAR) -- Show different publishers together with the number of publications they have. SELECT Publisher, COUNT(*) FROM publication GROUP BY Publisher CREATE TABLE publication (Publication_Date VARCHAR) -- Please show the most common publication date. SELECT Publication_Date FROM publication GROUP BY Publication_Date ORDER BY COUNT(*) DESC LIMIT 1 CREATE TABLE book (Writer VARCHAR) -- List the writers who have written more than one book. SELECT Writer FROM book GROUP BY Writer HAVING COUNT(*) > 1 CREATE TABLE book (Title VARCHAR, Book_ID VARCHAR); CREATE TABLE publication (Title VARCHAR, Book_ID VARCHAR) -- List the titles of books that are not published. SELECT Title FROM book WHERE NOT Book_ID IN (SELECT Book_ID FROM publication) CREATE TABLE publication (Publisher VARCHAR, Price INTEGER) -- Show the publishers that have publications with price higher than 10000000 and publications with price lower than 5000000. SELECT Publisher FROM publication WHERE Price > 10000000 INTERSECT SELECT Publisher FROM publication WHERE Price < 5000000 CREATE TABLE publication (Publication_Date VARCHAR) -- What is the number of distinct publication dates? SELECT COUNT(DISTINCT Publication_Date) FROM publication