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
Tell me the publisher of the book Bloody Mary : Lady Liberty.
assistant
SELECT T2.Publisher FROM book AS T1 JOIN publication AS T2 ON T1.Book_ID = T2.Book_ID WHERE T1.Title = 'Bloody Mary : Lady Liberty';
human
How many publications does this publisher have?
assistant
SELECT COUNT( * ) FROM publication WHERE Publisher = ( SELECT T2.Publisher FROM book AS T1 JOIN publication AS T2 ON T1.Book_ID = T2.Book_ID WHERE T1.Title = "Bloody Mary : Lady Liberty" ) ;