How many people are there?
select count(*) from people
How many people aged 40?
select count(*) from people where age = 40
How many people aged either 35 or 36?
select count(*) from people where age = 35 or age = 36
Please show their names.
select name from people where age = 35 or age = 36