CREATE TABLE office_locations (building_id NUMBER, company_id NUMBER, move_in_year NUMBER)
CREATE TABLE buildings (id NUMBER, name CLOB, city CLOB, height NUMBER, stories NUMBER, status CLOB)
CREATE TABLE companies (id NUMBER, name CLOB, headquarters CLOB, industry CLOB, sales_billion NUMBER, profits_billion NUMBER, assets_billion NUMBER, market_value_billion CLOB)

Sort all the industries in descending order of the count of companies in each industry
SELECT industry FROM companies GROUP BY industry ORDER BY COUNT(*) DESC
SELECT "industry" FROM "companies" GROUP BY "industry" ORDER BY COUNT(*) DESC