human
Schema:
candidate (Candidate_ID, People_ID, Poll_Source, Date, Support_rate, Consider_rate, Oppose_rate, Unsure_rate)
people (People_ID, Sex, Name, Date_of_Birth, Height, Weight)
Please answer with SQL.
assistant
Sure, I understand.
human
show the info of people who are taller than 200.
assistant
SELECT * FROM people WHERE height > 200;
human
also list the people whose height is lower than 190.
assistant
SELECT * FROM people WHERE height > 200 OR height < 190;
human
just show their names.
assistant
SELECT name FROM people WHERE height > 200 OR height < 190 ;