Database schema:
CREATE TABLE university (
  University_ID NUMBER PRIMARY KEY,
  University_Name TEXT,
  City TEXT,
  State TEXT,
  Team_Name TEXT,
  Affiliation TEXT,
  Enrollment NUMBER,
  Home_Conference TEXT
);
CREATE TABLE overall_ranking (
  Rank NUMBER,
  University_ID NUMBER PRIMARY KEY,
  Reputation_point NUMBER,
  Research_point NUMBER,
  Citation_point NUMBER,
  Total NUMBER,
  FOREIGN KEY (University_ID) REFERENCES university(University_ID)
);
CREATE TABLE major (
  Major_ID NUMBER PRIMARY KEY,
  Major_Name TEXT,
  Major_Code NUMBER
);
CREATE TABLE major_ranking (
  Rank NUMBER PRIMARY KEY,
  University_ID NUMBER,
  Major_ID NUMBER,
  FOREIGN KEY (Major_ID) REFERENCES major(Major_ID),
  FOREIGN KEY (University_ID) REFERENCES university(University_ID)
);

Question: What is the maximum, average, and minimum enrollment for universities?
SQL: SELECT max(enrollment) ,  avg(enrollment) ,  min(enrollment) FROM University

Question: What is the state with the most universities?
SQL: SELECT state FROM University GROUP BY state ORDER BY count(*) DESC LIMIT 1

Question: Show name, city, and state for all universities in  alphabetical order of university name.
SQL: SELECT university_name ,  city ,  state FROM University ORDER BY university_name

Question: What are the names of the university with an Accounting major ranked 3 or higher?
SQL: SELECT T2.university_name FROM Major_Ranking AS T1 JOIN University AS T2 JOIN Major AS T3 ON T1.university_id  =  T2.university_id AND T1.major_id  =  T3.major_id WHERE T1.rank  <=  3 AND T3.major_name  =  "Accounting"

Question: What is the total number of students enrolled in an university with a rank of 5 or below?
SQL: SELECT sum(enrollment) FROM University AS T1 JOIN Overall_ranking AS T2 ON T1.university_id  =  T2.university_id WHERE T2.rank  >=  5

Question: What is the name and overall ranking of universities in Wisconsin state?
SQL: SELECT T1.university_name ,  T2.rank FROM University AS T1 JOIN Overall_ranking AS T2 ON T1.university_id  =  T2.university_id WHERE T1.state  =  'Wisconsin'

Question: Which state has most number of universities?
SQL: SELECT state FROM University GROUP BY state ORDER BY count(*) DESC LIMIT 1

Question: What is the name of the university that has most number of majors with rank 1?
SQL: SELECT T2.university_name FROM Major_Ranking AS T1 JOIN University AS T2 ON T1.university_id  =  T2.university_id WHERE T1.rank  =  1 GROUP BY T2.university_name ORDER BY count(*) DESC LIMIT 1

Question: What are the names, cities, and states of all universities in alphabetical order (by name of the university).
SQL: SELECT university_name ,  city ,  state FROM University ORDER BY university_name

Question: Show all majors and major ranks for the university with name Augustana College.
SQL: SELECT T1.rank ,  T3.major_name FROM Major_Ranking AS T1 JOIN University AS T2 JOIN Major AS T3 ON T1.university_id  =  T2.university_id AND T1.major_id  =  T3.major_id WHERE T2.university_name  =  'Augustana College'

Question: What are the ranks and names of all majors at Augustana College?
SQL: SELECT T1.rank ,  T3.major_name FROM Major_Ranking AS T1 JOIN University AS T2 JOIN Major AS T3 ON T1.university_id  =  T2.university_id AND T1.major_id  =  T3.major_id WHERE T2.university_name  =  'Augustana College'

Question: What is the maximum, average, and minimum enrollment for all universities?
SQL: SELECT max(enrollment) ,  avg(enrollment) ,  min(enrollment) FROM University

Question: What are the names of all universities without any majors ranked number 1?
SQL: SELECT university_name FROM University EXCEPT SELECT T2.university_name FROM Major_Ranking AS T1 JOIN University AS T2 ON T1.university_id  =  T2.university_id WHERE T1.rank  =  1

Question: What is the name and citation point of the unversities with the top 3 reputation points?
SQL: SELECT T1.University_Name ,  T2.Citation_point FROM University AS T1 JOIN Overall_ranking AS T2 ON T1.university_id  =  T2.university_id ORDER BY T2.Reputation_point DESC LIMIT 3

Question: What are the names of all universities that have both Accounting and Urban Education majors?
SQL: SELECT T2.university_name FROM Major_Ranking AS T1 JOIN University AS T2 JOIN Major AS T3 ON T1.university_id  =  T2.university_id AND T1.major_id  =  T3.major_id WHERE T3.major_name  =  'Accounting' INTERSECT SELECT T2.university_name FROM Major_Ranking AS T1 JOIN University AS T2 JOIN Major AS T3 ON T1.university_id  =  T2.university_id AND T1.major_id  =  T3.major_id WHERE T3.major_name  =  'Urban Education'