What are the names of people who are shorter than average?
SELECT name FROM people WHERE height  <  (SELECT avg(height) FROM people)
shorter than average refers to height < AVG(height); names of people refers to SELECT name;