What shows for the Diameter (km) when the Diameter (mi) is 8mi, and a Gill is e?
CREATE TABLE table_name_66 (diameter__km_ VARCHAR, diameter__mi_ VARCHAR, gill VARCHAR)
SELECT diameter__km_ FROM table_name_66 WHERE diameter__mi_ = "8mi" AND gill = "e"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_66 (diameter__km_ VARCHAR, diameter__mi_ VARCHAR, gill VARCHAR) Question: What shows for the Diameter (km) when the Diameter (mi) is 8mi, and a Gill is e? [/INST] SELECT diameter__km_ FROM table_name_66 WHERE diameter__mi_ = "8mi" AND gill = "e" </s>