What is the name of the student who has the highest total credits in the History department?
select name from student where dept_name = 'History' order by tot_cred desc limit 1
how many students are in the history department?
select count ( name ) from student where dept_name = 'History'
what is the average total credits in the history department?
select avg ( tot_cred ) from student where dept_name = 'History'