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

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"