CREATE TABLE company (main_industry VARCHAR2, market_value NUMBER)

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"