What is the average age of people?
select min(age) from people
Show people whose age is smaller than the average.
select * from people where age < (select avg(age) from people)
What are their names and countries?
select name, country from people where age < (select avg(age) from people)