SELECT main_industry ,  sum(market_value) FROM company GROUP BY main_industry
What are the main indstries and total market value for each industry?
SELECT main_industry , sum ( market_value ) FROM company GROUP BY main_industry
select main_industry , sum ( market_value ) from company group by main_industry
What are the main indstries and total market value for each industry ?