Database: candidate_poll
Question: What are the names of people who are shorter than average?
SQL:
SELECT name FROM people WHERE height  <  (SELECT avg(height) FROM people)