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 are the home conferences with the fewest number of people enrolled?
SQL: SELECT home_conference FROM University GROUP BY home_conference ORDER BY sum(enrollment) LIMIT 1

Question: Show all university names without a major with rank 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: Show all home conferences with average enrollment of universities above 2000.
SQL: SELECT home_conference FROM University GROUP BY home_conference HAVING avg(enrollment)  >  2000

Question: What is the name of the university with the most research points?
SQL: SELECT T1.university_name FROM University AS T1 JOIN Overall_ranking AS T2 ON T1.university_id  =  T2.university_id ORDER BY T2.research_point DESC LIMIT 1

Question: What are the names of all universities in ascending order of reputation points?
SQL: SELECT T1.university_name FROM University AS T1 JOIN Overall_ranking AS T2 ON T1.university_id  =  T2.university_id ORDER BY T2.reputation_point

Question: List all major name and major code in the order of their major code
SQL: SELECT major_name ,  major_code FROM Major ORDER BY major_code

Question: List all university names in ascending order of their reputation points.
SQL: SELECT T1.university_name FROM University AS T1 JOIN Overall_ranking AS T2 ON T1.university_id  =  T2.university_id ORDER BY T2.reputation_point

Question: What is the name of university with major Accounting ranked 3 or above?
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 name and rank of every university in Wisconsin?
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: What is the total number of universities located in Illinois or Ohio?
SQL: SELECT count(*) FROM University WHERE state  =  'Illinois' OR state  =  'Ohio'

Question: What are the states that have more than 2 universities with an enrollment less than 3000?
SQL: SELECT state FROM university WHERE enrollment  <  3000 GROUP BY state HAVING count(*)  >  2

Question: For every home conference, how many universities attended that conference?
SQL: SELECT home_conference ,  count(*) FROM University GROUP BY home_conference

Question: What are the names and codes for all majors ordered by their code?
SQL: SELECT major_name ,  major_code FROM Major ORDER BY major_code

Question: What is the name, city, state of the university with a rank 1 on Accounting major?
SQL: SELECT T2.university_name ,  T2.city ,  T2.state 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  =  1 AND T3.major_name  =  'Accounting'

Question: What are the names of all teams from universities that have more people enrolled than average ?
SQL: select team_name from university where enrollment  >  (select avg(enrollment) from university)

Question: How many universities are in Illinois or Ohio?
SQL: SELECT count(*) FROM University WHERE state  =  'Illinois' OR state  =  'Ohio'

Question: What are the different home conferences from the university table?
SQL: SELECT DISTINCT home_conference FROM University

Question: What is the total enrollment of universities with a overall rank 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: Which conference has the least number of total enrollment?
SQL: SELECT home_conference FROM University GROUP BY home_conference ORDER BY sum(enrollment) LIMIT 1

Question: What is the name of the university with the most majors ranked number 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: Show all home conferences and the number of universities in each conference.
SQL: SELECT home_conference ,  count(*) FROM University GROUP BY home_conference

Question: which states do have more than two universities with enrollment smaller than 3000?
SQL: SELECT state FROM university WHERE enrollment  <  3000 GROUP BY state HAVING count(*)  >  2

Question: What is the name, city, and state of the university with number 1 ranked Accounting major?
SQL: SELECT T2.university_name ,  T2.city ,  T2.state 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  =  1 AND T3.major_name  =  'Accounting'

Question: Show all home conferences.
SQL: SELECT DISTINCT home_conference FROM University

Question: Find the name and Citation point of the universities whose reputation points are top 3 and above.
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 home conferences that have an average university enrollment above 2000?
SQL: SELECT home_conference FROM University GROUP BY home_conference HAVING avg(enrollment)  >  2000

Question: What is the university name with highest research point?
SQL: SELECT T1.university_name FROM University AS T1 JOIN Overall_ranking AS T2 ON T1.university_id  =  T2.university_id ORDER BY T2.research_point DESC LIMIT 1

Question: Show all university names with both major Accounting and major Urban Education.
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'

Question: List team name for all universities with enrollments above the average.
SQL: SELECT team_name FROM University WHERE enrollment  >  (SELECT avg(enrollment) FROM University)