text: CREATE TABLE Student (age VARCHAR) -- How many students are age 18? SELECT COUNT(*) FROM Student WHERE age = 18 CREATE TABLE Student (StuID VARCHAR, age INTEGER) -- Show all student ids who are older than 20. SELECT StuID FROM Student WHERE age > 20 CREATE TABLE Student (city_code VARCHAR, LName VARCHAR) -- Which city does the student whose last name is "Kim" live in? SELECT city_code FROM Student WHERE LName = "Kim" CREATE TABLE Student (Advisor VARCHAR, StuID VARCHAR) -- Who is the advisor of student with ID 1004? SELECT Advisor FROM Student WHERE StuID = 1004 CREATE TABLE Student (city_code VARCHAR) -- How many students live in HKG or CHI? SELECT COUNT(*) FROM Student WHERE city_code = "HKG" OR city_code = "CHI" CREATE TABLE Student (age INTEGER) -- Show the minimum, average, and maximum age of all students. SELECT MIN(age), AVG(age), MAX(age) FROM Student CREATE TABLE Student (LName VARCHAR, age INTEGER) -- What is the last name of the youngest student? SELECT LName FROM Student WHERE age = (SELECT MIN(age) FROM Student) CREATE TABLE Student (StuID VARCHAR, age INTEGER) -- Show the student id of the oldest student. SELECT StuID FROM Student WHERE age = (SELECT MAX(age) FROM Student) CREATE TABLE Student (major VARCHAR) -- Show all majors and corresponding number of students. SELECT major, COUNT(*) FROM Student GROUP BY major CREATE TABLE Student (major VARCHAR) -- Which major has most number of students? SELECT major FROM Student GROUP BY major ORDER BY COUNT(*) DESC LIMIT 1