When turquoise is the map colour how many avg. trips per mile (×1000)  are there?
CREATE TABLE table_17839_1 (avg_trips_per_mile__ VARCHAR, map_colour VARCHAR)
SELECT COUNT(avg_trips_per_mile__) AS ×1000_ FROM table_17839_1 WHERE map_colour = "Turquoise"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_17839_1 (avg_trips_per_mile__ VARCHAR, map_colour VARCHAR) Question: When turquoise is the map colour how many avg. trips per mile (×1000)  are there? [/INST] SELECT COUNT(avg_trips_per_mile__) AS ×1000_ FROM table_17839_1 WHERE map_colour = "Turquoise" </s>