text: CREATE TABLE Allergy_type (allergytype VARCHAR) -- Show all allergy types and the number of allergies in each type. SELECT allergytype, COUNT(*) FROM Allergy_type GROUP BY allergytype CREATE TABLE Allergy_type (allergytype VARCHAR) -- Which allergy type has most number of allergies? SELECT allergytype FROM Allergy_type GROUP BY allergytype ORDER BY COUNT(*) DESC LIMIT 1 CREATE TABLE Allergy_type (allergytype VARCHAR) -- Which allergy type has least number of allergies? SELECT allergytype FROM Allergy_type GROUP BY allergytype ORDER BY COUNT(*) LIMIT 1 CREATE TABLE Student (Id VARCHAR) -- How many students are there? SELECT COUNT(*) FROM Student CREATE TABLE Student (Fname VARCHAR, Lname VARCHAR) -- Show first name and last name for all students. SELECT Fname, Lname FROM Student CREATE TABLE Student (advisor VARCHAR) -- How many different advisors are listed? SELECT COUNT(DISTINCT advisor) FROM Student CREATE TABLE Student (Major VARCHAR) -- Show all majors. SELECT DISTINCT Major FROM Student CREATE TABLE Student (city_code VARCHAR) -- Show all cities where students live. SELECT DISTINCT city_code FROM Student CREATE TABLE Student (Fname VARCHAR, Lname VARCHAR, Age VARCHAR, Sex VARCHAR) -- Show first name, last name, age for all female students. Their sex is F. SELECT Fname, Lname, Age FROM Student WHERE Sex = 'F' CREATE TABLE Student (StuID VARCHAR, Sex VARCHAR) -- Show student ids for all male students. SELECT StuID FROM Student WHERE Sex = 'M'