text: Below is an context that describes a sql query, paired with an question that provides further information. Write an answer that appropriately completes the request.  # noqa: E501
  ### Context:
  CREATE TABLE company (main_industry VARCHAR, market_value INTEGER)
  ### Question:
  Show all main industry and total market value in each industry.
  ### Answer:
  SELECT main_industry, SUM(market_value) FROM company GROUP BY main_industry