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
how many publishers are there?
assistant
SELECT COUNT( distinct Publisher ) FROM publication ;