CREATE TABLE minor_in (stuid NUMBER, dno NUMBER)
CREATE TABLE enrolled_in (stuid NUMBER, cid CLOB, grade CLOB)
CREATE TABLE member_of (facid NUMBER, dno NUMBER, appt_type CLOB)
CREATE TABLE student (stuid NUMBER, lname CLOB, fname CLOB, age NUMBER, sex CLOB, major NUMBER, advisor NUMBER, city_code CLOB)
CREATE TABLE gradeconversion (lettergrade CLOB, gradepoint NUMBER)
CREATE TABLE department (dno NUMBER, division CLOB, dname CLOB, room CLOB, building CLOB, dphone NUMBER)
CREATE TABLE faculty (facid NUMBER, lname CLOB, fname CLOB, rank CLOB, sex CLOB, phone NUMBER, room CLOB, building CLOB)
CREATE TABLE course (cid CLOB, cname CLOB, credits NUMBER, instructor NUMBER, days CLOB, hours CLOB, dno NUMBER)

What are the first and last names of the instructors who teach the top 3 number of courses?
SELECT T2.fname, T2.lname FROM course AS T1 JOIN faculty AS T2 ON T1.instructor = T2.facid GROUP BY T1.instructor ORDER BY COUNT(*) DESC LIMIT 3
SELECT "T2"."fname", "T2"."lname" FROM "course" "T1" JOIN "faculty" "T2" ON "T1"."instructor" = "T2"."facid" GROUP BY "T1"."instructor" ORDER BY COUNT(*) DESC FETCH FIRST 3 ROWS ONLY