CREATE TABLE DEPARTMENT (DName VARCHAR2, DNO VARCHAR2)
CREATE TABLE MINOR_IN (DNO VARCHAR2)

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