CREATE TABLE table_name_10 (category VARCHAR2, start VARCHAR2, stage VARCHAR2)

What is the category for the year when Brioude started and the stage is less than 7?
SELECT COUNT(category) FROM table_name_10 WHERE start = "brioude" AND stage < 7
SELECT COUNT("category") FROM "table_name_10" WHERE "brioude" = "start" AND "stage" < 7