find the name of people whose height is lower than the average.
CREATE TABLE people (name VARCHAR, height INTEGER)
SELECT name FROM people WHERE height < (SELECT AVG(height) FROM people)
### Context: CREATE TABLE people (name VARCHAR, height INTEGER) ### Question: find the name of people whose height is lower than the average. ### Answer: SELECT name FROM people WHERE height < (SELECT AVG(height) FROM people)