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's the highest price of book published on this list?
assistant
SELECT MAX( T2.price ) FROM book AS T1 JOIN publication AS T2 ON T1.Book_ID = T2.Book_ID;
human
who's the writer of The Black Lamb?
assistant
SELECT T1.Writer FROM book AS T1 JOIN publication AS T2 ON T1.Book_ID = T2.Book_ID WHERE T1.Title = 'The Black Lamb';
human
what's the price for Wiley's publication? | Which of Wiley's publications do you want to know the price for? | the one of june 2006
assistant
SELECT T2.Price FROM book AS T1 JOIN publication AS T2 ON T1.Book_ID = T2.Book_ID WHERE T2.Publisher = "Wiley" AND T2.Publication_Date = "June 2006" ;