CREATE TABLE personfriend (name TEXT, friend TEXT, year DECIMAL)
CREATE TABLE person (name TEXT, age DECIMAL, city TEXT, gender TEXT, job TEXT)

How many different cities do people originate from?
SELECT COUNT(DISTINCT city) FROM person
SELECT COUNT(DISTINCT "city") FROM "person"