human
Schema:
publication (Publication_ID, Book_ID, Publisher, Publication_Date, Price)
book (Book_ID, Title, Issues, Writer)
Please answer with SQL.
assistant
Sure, I understand.
human
What are the publication dates in the list?
assistant
SELECT Publication_Date FROM publication;
human
Can you sort the list by publication date from most common to least common?
assistant
SELECT Publication_Date FROM publication GROUP BY Publication_Date ORDER BY COUNT( * ) DESC ;