SELECT main_industry ,  sum(market_value) FROM company GROUP BY main_industry
Show all main industry and total market value in 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
Show all main industry and total market value in each industry .