Database: gas_company
Question: What are the main indstries and total market value for each industry?
SQL:
SELECT main_industry ,  sum(market_value) FROM company GROUP BY main_industry