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 FLOAT, Profits_billion FLOAT, Assets_billion FLOAT, Market_Value FLOAT)
CREATE TABLE gas_station (Station_ID INT, Open_Year INT, Location TEXT, Manager_Name TEXT, Vice_Manager_Name TEXT, Representative_Name TEXT)

How many companies without a gas station in each main industry? Draw a pie chart.
SELECT Main_Industry, COUNT(Main_Industry) FROM company WHERE NOT Company_ID IN (SELECT Company_ID FROM station_company) GROUP BY Main_Industry
SELECT "Main_Industry", COUNT("Main_Industry") FROM "company" WHERE NOT "Company_ID" IN (SELECT "Company_ID" FROM "station_company") GROUP BY "Main_Industry"