Schema: CREATE TABLE company (main_industry VARCHAR, market_value INTEGER)
Question: Show all main industry and total market value in each industry.
SQL: SELECT main_industry, SUM(market_value) FROM company GROUP BY main_industry