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
I want to know the publication price of the book with title 'Cyberella'?
assistant
SELECT T2.Price FROM book AS T1 JOIN publication AS T2 ON T1.Book_ID = T2.Book_ID WHERE T1.Title = 'Cyberella';
human
Could you show me all the books' publication price?
assistant
SELECT T2.Price FROM book AS T1 JOIN publication AS T2 ON T1.Book_ID = T2.Book_ID ;