CREATE TABLE people (name VARCHAR, height INT)

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