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

HOw many engineers are older than 30?
SELECT COUNT(*) FROM person WHERE age > 30 AND job = 'engineer'
SELECT COUNT(*) FROM "person" WHERE "age" > 30 AND "job" = 'engineer'