For each city, how many branches opened before 2010?
CREATE TABLE purchase (
    member_id number,
    branch_id text,
    year text,
    total_pounds number
)

CREATE TABLE membership_register_branch (
    member_id number,
    branch_id text,
    register_year text
)

CREATE TABLE branch (
    branch_id number,
    name text,
    open_year text,
    address_road text,
    city text,
    membership_amount text
)

CREATE TABLE member (
    member_id number,
    card_number text,
    name text,
    hometown text,
    level number
)
SELECT city, COUNT(*) FROM branch WHERE open_year < 2010 GROUP BY city
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: For each city, how many branches opened before 2010? ### Input: CREATE TABLE purchase (
    member_id number,
    branch_id text,
    year text,
    total_pounds number
)

CREATE TABLE membership_register_branch (
    member_id number,
    branch_id text,
    register_year text
)

CREATE TABLE branch (
    branch_id number,
    name text,
    open_year text,
    address_road text,
    city text,
    membership_amount text
)

CREATE TABLE member (
    member_id number,
    card_number text,
    name text,
    hometown text,
    level number
) ### Response: SELECT city, COUNT(*) FROM branch WHERE open_year < 2010 GROUP BY city