SELECT name FROM people WHERE height  <  (SELECT avg(height) FROM people)
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 )
find the name of people whose height is lower than the average .