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 é o valor de mercado da indústria automotiva?
 ###Tabelas: CREATE TABLE first_quarter (first_quarter_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Name VARCHAR, Headquarters VARCHAR, Industry VARCHAR, Market value ( USD million) INT) CREATE TABLE largest_cities (largest_cities_id AUTO_INCREMENT PRIMARY KEY, City proper VARCHAR, Population City limits in millions INT, Density per km² INT, Urban area VARCHAR, Population Urban area in millions INT, Metro area VARCHAR, Population Metro area in millions VARCHAR) CREATE TABLE composition_of_the_7th_seanad (composition_of_the_7th_seanad_id AUTO_INCREMENT PRIMARY KEY, Administrative Panel INT, Agricultural Panel INT, Cultural and Educational Panel INT, Industrial and Commercial Panel INT, Labour Panel INT, National University of Ireland INT, University of Dublin INT, Nominated by the Taoiseach INT, Total INT) CREATE TABLE overview (overview_id AUTO_INCREMENT PRIMARY KEY, Club VARCHAR, Location VARCHAR, Stadium VARCHAR, Capacity INT, Manager VARCHAR) CREATE TABLE points_for_the_2007_08_season (points_for_the_2007_08_season_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Pld. INT, Goals INT, Assists INT, Points INT, Pims INT)  
SELECT COUNT Market value ( USD million) FROM first_quarter WHERE Industry = automotive