human
Schema:
Person (name, age, city, gender, job)
PersonFriend (name, friend, year)
Please answer with SQL.
assistant
Sure, I understand.
human
How old is the student? | Which student are you referring to? | A better question is, how many students are there?
assistant
SELECT COUNT( * ) FROM Person WHERE job = 'student';
human
What about the number of people with occupations? | By occupations, do you mean people who are not students? | Yes
assistant
SELECT COUNT( * ) FROM Person WHERE job ! = 'student';
human
What are their names?
assistant
SELECT name FROM Person WHERE job ! = 'student';
human
And the names of the people who are not students?
assistant
SELECT name FROM Person WHERE job ! = "student" ;