What is the category for the year when Brioude started and the stage is less than 7?
CREATE TABLE "appearances_in_the_tour_de_france" (
  "year" real,
  "stage" real,
  "category" real,
  "start" text,
  "finish" text,
  "leader_at_the_summit" text
);
SELECT COUNT("category") FROM "appearances_in_the_tour_de_france" WHERE "start"='brioude' AND "stage"<7;