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 need a list of the titles of books.
assistant
SELECT Title FROM book;
human
Can you give me the price of those books?
assistant
SELECT t2.price FROM book AS t1 JOIN publication AS t2 ON t1.book_id = t2.book_id ;