CREATE TABLE company (main_industry VARCHAR2, market_value NUMBER)

List the main industry with highest total market value and its number of companies.
SELECT main_industry, COUNT(*) FROM company GROUP BY main_industry ORDER BY SUM(market_value) DESC LIMIT 1
SELECT "main_industry", COUNT(*) FROM "company" GROUP BY "main_industry" ORDER BY SUM("market_value") DESC FETCH FIRST 1 ROWS ONLY