Tell me the publisher of the book Bloody Mary : Lady Liberty.
select t2.publisher from book as t1 join publication as t2 on t1.book_id = t2.book_id where t1.title = "Bloody mary : lady Liberty"
How about the publisher of the book with title Gemini Blood?
select t2.publisher from book as t1 join publication as t2 on t1.book_id = t2.book_id where t1.title = "Gemini Blood"
Tell me the books that are not published.
select title from book where book_id not in (select book_id from publication)