What are the names of people who are shorter than average?
select name from people where height < (select avg(height) from people)