Table: longest_novels
Columns: book_title
author
edition_publisher
page_count
page_size
language

Question: How many pages were in the book by Stefano D'Arrigo?
SQL: SELECT "page_count" FROM longest_novels WHERE "author" = 'stefano d''arrigo'

Question: Which author wrote Sironia, Texas in English?
SQL: SELECT "author" FROM longest_novels WHERE "language" = 'english' AND "book_title" = 'sironia, texas'

Question: Who is the edition/publisher for Xavier Herbert?
SQL: SELECT "edition_publisher" FROM longest_novels WHERE "author" = 'xavier herbert'

Question: What language is the book Miss Macintosh, My Darling in?
SQL: SELECT "language" FROM longest_novels WHERE "book_title" = 'miss macintosh, my darling'

Question: Who published in Italian with a page size of 8 inches (20cm) x 5.4 inches (14cm)?
SQL: SELECT "edition_publisher" FROM longest_novels WHERE "language" = 'italian' AND "page_size" = '8 inches (20cm) x 5.4 inches (14cm)'