SELECT COUNT(DISTINCT city) FROM person
How many different cities do people originate from?
CREATE TABLE personfriend (
    name text,
    friend text,
    year number
)

CREATE TABLE person (
    name text,
    age number,
    city text,
    gender text,
    job text
)