What is the name of the student who has the highest total credits in the History department.
CREATE TABLE student (name VARCHAR, dept_name VARCHAR, tot_cred VARCHAR)
[SQL] SELECT name FROM student WHERE dept_name = 'History' ORDER BY tot_cred DESC LIMIT 1 [/SQL]