can you show me a list of people names?
select name from people
can you show me the oldest one?
select name from people order by age desc limit 1
can you show me average of ages?
select avg ( age ) from people
Show the party that has the most people
select party from people group by party order by count ( * ) desc limit 1