Find the name of instructor who is the advisor of the student who has the highest number of total credits.
SELECT T2.name FROM advisor AS T1 JOIN instructor AS T2 ON T1.i_id  =  T2.id JOIN student AS T3 ON T1.s_id  =  T3.id ORDER BY T3.tot_cred DESC LIMIT 1
instructor who is the advisor of the student with the highest number of total credits refers to joining tables advisor, instructor, and student on respective keys and ordering by total credits (tot_cred) in descending order to find the top one.