SELECT Main_Industry, SUM(Market_Value) FROM company GROUP BY Main_Industry ORDER BY SUM(Market_Value) DESC
what are the main indstries and total market value for each industry?, and sort by the Y in descending.
CREATE TABLE gas_station (
    Station_ID int,
    Open_Year int,
    Location text,
    Manager_Name text,
    Vice_Manager_Name text,
    Representative_Name text
)

CREATE TABLE station_company (
    Station_ID int,
    Company_ID int,
    Rank_of_the_Year int
)

CREATE TABLE company (
    Company_ID int,
    Rank int,
    Company text,
    Headquarters text,
    Main_Industry text,
    Sales_billion real,
    Profits_billion real,
    Assets_billion real,
    Market_Value real
)