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