Table schema:
CREATE TABLE people (name VARCHAR, height INTEGER)

Question: find the name of people whose height is lower than the average.
SQL: SELECT name FROM people WHERE height < (SELECT AVG(height) FROM people)