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 writer of Gemini Blood.
assistant
SELECT Writer FROM book WHERE Title = 'Gemini Blood';
human
Tell me all the books he wrote.
assistant
SELECT Title FROM book WHERE Writer = ( SELECT Writer FROM book WHERE Title = 'Gemini Blood' );
human
Okay, show me the writers who have written more than one book.
assistant
SELECT Writer FROM book GROUP BY Writer HAVING COUNT( * ) > 1 ;