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

Find the name of the department that has the biggest number of students minored in?
SELECT T1.dname FROM department AS T1 JOIN minor_in AS T2 ON T1.dno = T2.dno GROUP BY T2.dno ORDER BY COUNT(*) DESC LIMIT 1
SELECT "T1"."dname" FROM "department" "T1" JOIN "minor_in" "T2" ON "T1"."dno" = "T2"."dno" GROUP BY "T2"."dno" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY