What is the market value of the automotive industry?
CREATE TABLE table_name_10 (market_value___usd_million_ VARCHAR, industry VARCHAR)
SELECT COUNT(market_value___usd_million_) FROM table_name_10 WHERE industry = "automotive"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_10 (market_value___usd_million_ VARCHAR, industry VARCHAR) Question: What is the market value of the automotive industry? [/INST] SELECT COUNT(market_value___usd_million_) FROM table_name_10 WHERE industry = "automotive" </s>