Database: gas_company
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