CREATE TABLE Companies (id INT, name TEXT, Headquarters TEXT, Industry TEXT, Sales_billion FLOAT, Profits_billion FLOAT, Assets_billion FLOAT, Market_Value_billion TEXT)
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)

a pie chart about the number of companies in different industries.
SELECT Industry, COUNT(*) FROM Companies GROUP BY Industry
SELECT "Industry", COUNT(*) FROM "Companies" GROUP BY "Industry"