Show all main industry and total market value in each industry.
CREATE TABLE company (main_industry VARCHAR, market_value INTEGER)
SELECT main_industry, SUM(market_value) FROM company GROUP BY main_industry
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE company (main_industry VARCHAR, market_value INTEGER) Question: Show all main industry and total market value in each industry. [/INST] SELECT main_industry, SUM(market_value) FROM company GROUP BY main_industry </s>