how many count in male or female in the student table
select count ( * ), sex from student group by sex