Abaixo está uma instrução que descreve uma tarefa de geração de SQL, combinada com uma entrada que fornece mais contexto sobre os esquemas de tabela disponíveis. Escreva o código SQL que responda adequadamente à solicitação
 ###Instrução: Qual é a categoria para o ano em que Brioude começou e a etapa é inferior a 7?
 ###Tabelas: CREATE TABLE appearances_in_the_tour_de_france (appearances_in_the_tour_de_france_id AUTO_INCREMENT PRIMARY KEY, Year INT, Stage INT, Category INT, Start VARCHAR, Finish VARCHAR, Leader at the summit VARCHAR) CREATE TABLE mutya_ng_pilipinas_asia_pacific_titleholders_and_runners-up (mutya_ng_pilipinas_asia_pacific_titleholders_and_runners-up_id AUTO_INCREMENT PRIMARY KEY, Year INT, Mutya ng Pilipinas Asia Pacific VARCHAR, 1st runner-up VARCHAR, 2nd runner-up VARCHAR, 3rd runner-up VARCHAR, 4th runner-up VARCHAR) CREATE TABLE playoffs_12 (playoffs_12_id AUTO_INCREMENT PRIMARY KEY, Team 1 VARCHAR, Agg. VARCHAR, Team 2 VARCHAR, 1st leg VARCHAR, 2nd leg VARCHAR) CREATE TABLE episode_information (episode_information_id AUTO_INCREMENT PRIMARY KEY, Episode Number VARCHAR, Broadcast Date VARCHAR, Title VARCHAR, Written by VARCHAR, Viewership (Millions) INT) CREATE TABLE reconstruction_in_the_british_museum (reconstruction_in_the_british_museum_id AUTO_INCREMENT PRIMARY KEY, Image INT, Smith VARCHAR, Ashmolean INT, Foster INT, Hahland INT, Dinsmoor VARCHAR, Hofkes-Brukker VARCHAR, Harrison VARCHAR, Cooper VARCHAR, BM/Corbett VARCHAR)  
SELECT COUNT Category FROM appearances_in_the_tour_de_france WHERE Start = brioude AND Stage < 7