CREATE TABLE Office_locations (building_id INT, company_id INT, move_in_year INT)
CREATE TABLE buildings (id INT, name TEXT, City TEXT, Height INT, Stories INT, Status TEXT)
CREATE TABLE Companies (id INT, name TEXT, Headquarters TEXT, Industry TEXT, Sales_billion FLOAT, Profits_billion FLOAT, Assets_billion FLOAT, Market_Value_billion TEXT)

, and show in desc by the total number.
SELECT Industry, COUNT(*) FROM Companies GROUP BY Industry ORDER BY COUNT(*) DESC
SELECT "Industry", COUNT(*) FROM "Companies" GROUP BY "Industry" ORDER BY COUNT(*) DESC NULLS LAST