text: CREATE TABLE SECTION (YEAR VARCHAR) -- Find the year which offers the largest number of courses. SELECT YEAR FROM SECTION GROUP BY YEAR ORDER BY COUNT(*) DESC LIMIT 1 CREATE TABLE SECTION (semester VARCHAR, YEAR VARCHAR) -- Find the year and semester when offers the largest number of courses. SELECT semester, YEAR FROM SECTION GROUP BY semester, YEAR ORDER BY COUNT(*) DESC LIMIT 1 CREATE TABLE student (dept_name VARCHAR) -- Find the name of department has the highest amount of students? SELECT dept_name FROM student GROUP BY dept_name ORDER BY COUNT(*) DESC LIMIT 1 CREATE TABLE student (dept_name VARCHAR) -- Find the total number of students in each department. SELECT COUNT(*), dept_name FROM student GROUP BY dept_name CREATE TABLE takes (semester VARCHAR, YEAR VARCHAR) -- Find the semester and year which has the least number of student taking any class. SELECT semester, YEAR FROM takes GROUP BY semester, YEAR ORDER BY COUNT(*) LIMIT 1 CREATE TABLE advisor (s_id VARCHAR); CREATE TABLE student (id VARCHAR, dept_name VARCHAR) -- What is the id of the instructor who advises of all students from History department? SELECT i_id FROM advisor AS T1 JOIN student AS T2 ON T1.s_id = T2.id WHERE T2.dept_name = 'History' CREATE TABLE instructor (name VARCHAR, salary VARCHAR, id VARCHAR); CREATE TABLE advisor (i_id VARCHAR, s_id VARCHAR); CREATE TABLE student (id VARCHAR, dept_name VARCHAR) -- Find the name and salary of the instructors who are advisors of any student from History department? SELECT T2.name, T2.salary FROM advisor AS T1 JOIN instructor AS T2 ON T1.i_id = T2.id JOIN student AS T3 ON T1.s_id = T3.id WHERE T3.dept_name = 'History'