what are the names of people whose weight is less than 85?
select name from people where weight < 85
how about those whose weight is greater than 85?
select name from people where weight > 85
how many are there in total?
select count(*) from people where weight > 85
what is the number for each gender?
select count(*), sex from people where weight > 85 group by sex