What are the different sex categories for students?
select distinct sex from student
How many are there for each category?
select count(*), sex from student group by sex
What is the average age for each category?
select avg(age), sex from student group by sex