CREATE TABLE station_company (Station_ID NUMBER, Company_ID NUMBER, Rank_of_the_Year NUMBER)
CREATE TABLE gas_station (Station_ID NUMBER, Open_Year NUMBER, Location CLOB, Manager_Name CLOB, Vice_Manager_Name CLOB, Representative_Name CLOB)
CREATE TABLE company (Company_ID NUMBER, Rank NUMBER, Company CLOB, Headquarters CLOB, Main_Industry CLOB, Sales_billion FLOAT, Profits_billion FLOAT, Assets_billion FLOAT, Market_Value FLOAT)

How many companies without a gas station in each main industry? Draw a bar chart, order y axis in descending order.
SELECT Main_Industry, COUNT(Main_Industry) FROM company WHERE NOT Company_ID IN (SELECT Company_ID FROM station_company) GROUP BY Main_Industry ORDER BY COUNT(Main_Industry) DESC
SELECT "Main_Industry", COUNT("Main_Industry") FROM "company" WHERE NOT "Company_ID" IN (SELECT "Company_ID" FROM "station_company") GROUP BY "Main_Industry" ORDER BY COUNT("Main_Industry") DESC