What are all students?
select * from student
How many of them?
select count(*) from student
How many are there in each department?
select count(*), dept_code from student group by dept_code