SELECT name FROM student WHERE dept_name  =  'History' ORDER BY tot_cred DESC LIMIT 1
Give the name of the student in the History department with the most credits.
SELECT name FROM student WHERE dept_name = 'History ' ORDER BY tot_cred DESC LIMIT 1
select name from student where dept_name = value order by tot_cred desc limit value
Give the name of the student in the History department with the most credits .