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 are the prices of the 3 lowest publications?
assistant
SELECT Price FROM publication ORDER BY Price ASC LIMIT 3;
human
And who are the publishers of the 3 lowest priced publications?
assistant
SELECT Publisher FROM publication ORDER BY Price ASC LIMIT 3;
human
What are the publication dates of the 3 lowest priced publications?
assistant
SELECT Publication_Date FROM publication ORDER BY Price ASC LIMIT 3 ;