CREATE TABLE student (dept_code VARCHAR2)
CREATE TABLE department (dept_name VARCHAR2, dept_address VARCHAR2, dept_code VARCHAR2)

Find the name and address of the department that has the highest number of students.
SELECT T2.dept_name, T2.dept_address FROM student AS T1 JOIN department AS T2 ON T1.dept_code = T2.dept_code GROUP BY T1.dept_code ORDER BY COUNT(*) DESC LIMIT 1
SELECT "T2"."dept_name", "T2"."dept_address" FROM "student" "T1" JOIN "department" "T2" ON "T1"."dept_code" = "T2"."dept_code" GROUP BY "T1"."dept_code" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY