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
highest total credits = MAX(tot_cred); in the History department refers to dept_name = 'History'; name of the student refers to SELECT name;