Table: mystery_series
Columns: japanese_title
english_title
year
first_publisher
isbn

Question: What is the First Publisher prior to 1999?
SQL: SELECT "first_publisher" FROM mystery_series WHERE "year" < 1999

Question: What is the ISBN in 1999?
SQL: SELECT "isbn" FROM mystery_series WHERE "year" = 1999

Question: What is the ISBN of Japanese Title of 霧の訪問者 (kiri no hōmonsha)?
SQL: SELECT "isbn" FROM mystery_series WHERE "japanese_title" = '霧の訪問者 (kiri no hōmonsha)'

Question: What is the First Publisher in 2007?
SQL: SELECT "first_publisher" FROM mystery_series WHERE "year" = 2007

Question: What is the Year of Kodansha Novels' Tokyo Nightmare?
SQL: SELECT "year" FROM mystery_series WHERE "first_publisher" = 'kodansha novels' AND "english_title" = 'tokyo nightmare'

Question: What Year has an ISBN OF ISBN 4-06-182042-7?
SQL: SELECT AVG("year") FROM mystery_series WHERE "isbn" = 'isbn 4-06-182042-7'