Return a bar chart showing the number of companies in each building.
CREATE TABLE Office_locations (
    building_id int,
    company_id int,
    move_in_year int
)

CREATE TABLE Companies (
    id int,
    name text,
    Headquarters text,
    Industry text,
    Sales_billion real,
    Profits_billion real,
    Assets_billion real,
    Market_Value_billion text
)

CREATE TABLE buildings (
    id int,
    name text,
    City text,
    Height int,
    Stories int,
    Status text
)
SELECT T2.name, COUNT(T2.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 T2.name
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Return a bar chart showing the number of companies in each building. ### Input: CREATE TABLE Office_locations (
    building_id int,
    company_id int,
    move_in_year int
)

CREATE TABLE Companies (
    id int,
    name text,
    Headquarters text,
    Industry text,
    Sales_billion real,
    Profits_billion real,
    Assets_billion real,
    Market_Value_billion text
)

CREATE TABLE buildings (
    id int,
    name text,
    City text,
    Height int,
    Stories int,
    Status text
) ### Response: SELECT T2.name, COUNT(T2.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 T2.name