Which course has km (mi) as a type?
CREATE TABLE "stage_results" (
  "date" text,
  "course" text,
  "distance" text,
  "type" text,
  "winner" text
);
SELECT "course" FROM "stage_results" WHERE "type"='km (mi)';