List the main industry with highest total market value and its number of companies.
CREATE TABLE company (main_industry VARCHAR, market_value INTEGER)
SELECT TOP 1 main_industry, COUNT(*) FROM company GROUP BY main_industry ORDER BY SUM(market_value) DESC
<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: List the main industry with highest total market value and its number of companies. [/INST] SELECT TOP 1 main_industry, COUNT(*) FROM company GROUP BY main_industry ORDER BY SUM(market_value) DESC </s>