How many people are older than 20?
select count(*) from person where age > 20
How about 30?
select count(*) from person where age > 30
How many engineers are there?
select count(*) from person where job = 'engineer'
How many people are both engineers and are over 30 years old?
select count(*) from person where age > 30 and job = 'engineer'