SELECT main_industry, SUM(market_value) FROM company GROUP BY main_industry
Tunjukkan semua industri utama dan total nilai pasar di setiap industri.
CREATE TABLE company (main_industry VARCHAR, market_value INTEGER)