How many distance places have brisbane at $3.80?
CREATE TABLE "public_transport_pricing" (
  "distance" text,
  "adelaide" text,
  "brisbane" text,
  "canberra" text,
  "melbourne" text,
  "perth" text,
  "sydney" text
);
SELECT COUNT("distance") FROM "public_transport_pricing" WHERE "brisbane"='$3.80';