How many faculty members does each building have? List the result with the name of the building.
CREATE TABLE participates_in (
    stuid number,
    actid number
)

CREATE TABLE activity (
    actid number,
    activity_name text
)

CREATE TABLE faculty (
    facid number,
    lname text,
    fname text,
    rank text,
    sex text,
    phone number,
    room text,
    building text
)

CREATE TABLE student (
    stuid number,
    lname text,
    fname text,
    age number,
    sex text,
    major number,
    advisor number,
    city_code text
)

CREATE TABLE faculty_participates_in (
    facid number,
    actid number
)
SELECT building, COUNT(*) FROM faculty GROUP BY building
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: How many faculty members does each building have? List the result with the name of the building. ### Input: CREATE TABLE participates_in (
    stuid number,
    actid number
)

CREATE TABLE activity (
    actid number,
    activity_name text
)

CREATE TABLE faculty (
    facid number,
    lname text,
    fname text,
    rank text,
    sex text,
    phone number,
    room text,
    building text
)

CREATE TABLE student (
    stuid number,
    lname text,
    fname text,
    age number,
    sex text,
    major number,
    advisor number,
    city_code text
)

CREATE TABLE faculty_participates_in (
    facid number,
    actid number
) ### Response: SELECT building, COUNT(*) FROM faculty GROUP BY building