how many students of each gender are there?
select count(*), sex from student group by sex
Find the average and oldest age for each gender.
select avg(age), max(age), sex from student group by sex