Show different locations and the number of performances at each location.
CREATE TABLE member_attendance (
    member_id number,
    performance_id number,
    num_of_pieces number
)

CREATE TABLE member (
    member_id text,
    name text,
    nationality text,
    role text
)

CREATE TABLE performance (
    performance_id number,
    date text,
    host text,
    location text,
    attendance number
)
SELECT location, COUNT(*) FROM performance GROUP BY location
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: Show different locations and the number of performances at each location. ### Input: CREATE TABLE member_attendance (
    member_id number,
    performance_id number,
    num_of_pieces number
)

CREATE TABLE member (
    member_id text,
    name text,
    nationality text,
    role text
)

CREATE TABLE performance (
    performance_id number,
    date text,
    host text,
    location text,
    attendance number
) ### Response: SELECT location, COUNT(*) FROM performance GROUP BY location