CREATE TABLE table_17839_1 (avg_trips_per_mile__ VARCHAR, map_colour VARCHAR)

When turquoise is the map colour how many avg. trips per mile ( 1000) are there?
SELECT COUNT(avg_trips_per_mile__) AS ×1000_ FROM table_17839_1 WHERE map_colour = "Turquoise"
SELECT COUNT("avg_trips_per_mile__") AS "×1000_" FROM "table_17839_1" WHERE "Turquoise" = "map_colour"