CREATE TABLE buildings (id NUMBER, name CLOB, City CLOB, Height NUMBER, Stories NUMBER, Status CLOB)
CREATE TABLE Office_locations (building_id NUMBER, company_id NUMBER, move_in_year NUMBER)
CREATE TABLE Companies (id NUMBER, name CLOB, Headquarters CLOB, Industry CLOB, Sales_billion FLOAT, Profits_billion FLOAT, Assets_billion FLOAT, Market_Value_billion CLOB)

List the number of each company whose office is in the building in a bar chart, list by the x-axis in asc.
SELECT T3.name, COUNT(T3.name) FROM Office_locations AS T1 JOIN buildings AS T2 ON T1.building_id = T2.id JOIN Companies AS T3 ON T1.company_id = T3.id GROUP BY T3.name ORDER BY T3.name
SELECT "T3"."name", COUNT("T3"."name") FROM "Office_locations" "T1" JOIN "buildings" "T2" ON "T1"."building_id" = "T2"."id" JOIN "Companies" "T3" ON "T1"."company_id" = "T3"."id" GROUP BY "T3"."name" ORDER BY "T3"."name"