Which author wrote Sironia, Texas in English?
CREATE TABLE table_name_42 (author VARCHAR, language VARCHAR, book_title VARCHAR)
SELECT author FROM table_name_42 WHERE language = "english" AND book_title = "sironia, texas"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_42 (author VARCHAR, language VARCHAR, book_title VARCHAR) Question: Which author wrote Sironia, Texas in English? [/INST] SELECT author FROM table_name_42 WHERE language = "english" AND book_title = "sironia, texas" </s>