CREATE TABLE restaurant_type (restypeid NUMBER, restypename CLOB, restypedescription CLOB)
CREATE TABLE student (stuid NUMBER, lname CLOB, fname CLOB, age NUMBER, sex CLOB, major NUMBER, advisor NUMBER, city_code CLOB)
CREATE TABLE type_of_restaurant (resid NUMBER, restypeid NUMBER)
CREATE TABLE restaurant (resid NUMBER, resname CLOB, address CLOB, rating NUMBER)
CREATE TABLE visits_restaurant (stuid NUMBER, resid NUMBER, time TIME, spent NUMBER)

Which major has least number of students? List the major and the number of students.
SELECT major, COUNT(*) FROM student GROUP BY major ORDER BY COUNT(major) LIMIT 1
SELECT "major", COUNT(*) FROM "student" GROUP BY "major" ORDER BY COUNT("major") FETCH FIRST 1 ROWS ONLY