CREATE TABLE teaches (id CLOB, course_id CLOB, sec_id CLOB, semester CLOB, year NUMBER)
CREATE TABLE department (dept_name CLOB, building CLOB, budget NUMBER)
CREATE TABLE student (id CLOB, name CLOB, dept_name CLOB, tot_cred NUMBER)
CREATE TABLE section (course_id CLOB, sec_id CLOB, semester CLOB, year NUMBER, building CLOB, room_number CLOB, time_slot_id CLOB)
CREATE TABLE time_slot (time_slot_id CLOB, day CLOB, start_hr NUMBER, start_min NUMBER, end_hr NUMBER, end_min NUMBER)
CREATE TABLE course (course_id CLOB, title CLOB, dept_name CLOB, credits NUMBER)
CREATE TABLE prereq (course_id CLOB, prereq_id CLOB)
CREATE TABLE instructor (id CLOB, name CLOB, dept_name CLOB, salary NUMBER)
CREATE TABLE takes (id CLOB, course_id CLOB, sec_id CLOB, semester CLOB, year NUMBER, grade CLOB)
CREATE TABLE advisor (s_id CLOB, i_id CLOB)
CREATE TABLE classroom (building CLOB, room_number CLOB, capacity NUMBER)

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
SELECT "T2"."name" FROM "advisor" "T1" JOIN "instructor" "T2" ON "T1"."i_id" = "T2"."id" JOIN "student" "T3" ON "T1"."s_id" = "T3"."id" ORDER BY "T3"."tot_cred" DESC FETCH FIRST 1 ROWS ONLY