CREATE TABLE station_company (Station_ID NUMBER, Company_ID NUMBER, Rank_of_the_Year NUMBER)
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)
CREATE TABLE gas_station (Station_ID NUMBER, Open_Year NUMBER, Location CLOB, Manager_Name CLOB, Vice_Manager_Name CLOB, Representative_Name CLOB)

For each company id, what are the companies and how many gas stations does each one operate Plot them as bar chart, and order bars in descending order.
SELECT Company, COUNT(*) FROM station_company AS T1 JOIN company AS T2 ON T1.Company_ID = T2.Company_ID GROUP BY T1.Company_ID ORDER BY Company DESC
SELECT "Company", COUNT(*) FROM "station_company" "T1" JOIN "company" "T2" ON "T1"."Company_ID" = "T2"."Company_ID" GROUP BY "T1"."Company_ID" ORDER BY "Company" DESC