Database schema:
CREATE TABLE institution (
  Institution_ID NUMBER PRIMARY KEY,
  Name TEXT,
  Team TEXT,
  City TEXT,
  Province TEXT,
  Founded NUMBER,
  Affiliation TEXT,
  Enrollment NUMBER,
  Endowment TEXT,
  Stadium TEXT,
  Capacity NUMBER
);
CREATE TABLE Championship (
  Institution_ID NUMBER PRIMARY KEY,
  Nickname TEXT,
  Joined NUMBER,
  Number_of_Championships NUMBER,
  FOREIGN KEY (Institution_ID) REFERENCES institution(Institution_ID)
);

Question: List the names of institutions in descending order of the number of championships.
SQL: SELECT T2.Name FROM championship AS T1 JOIN institution AS T2 ON T1.Institution_ID  =  T2.Institution_ID ORDER BY T1.Number_of_Championships DESC

Question: Return the cities and provinces of institutions.
SQL: SELECT City ,  Province FROM institution

Question: Return all the enrollments of institutions in either the city of Vancouver or the city of Calgary .
SQL: select sum(enrollment) from institution where city  =  "vancouver" or city  =  "calgary"

Question: Show the provinces that have both institutions founded before 1920 and institutions founded after 1950.
SQL: SELECT Province FROM institution WHERE Founded  <  1920 INTERSECT SELECT Province FROM institution WHERE Founded  >  1950

Question: What are the cities and provinces of institutions?
SQL: SELECT City ,  Province FROM institution

Question: Count the number of institutions.
SQL: SELECT count(*) FROM institution

Question: What are the names and nicknames of institutions?
SQL: SELECT T2.Name ,  T1.Nickname FROM championship AS T1 JOIN institution AS T2 ON T1.Institution_ID  =  T2.Institution_ID

Question: What are the affiliations of institutions that are not in city "Vancouver"?
SQL: SELECT Affiliation FROM institution WHERE City != "Vancouver"

Question: What are the names of institutions, ordered by the years in which they were founded?
SQL: SELECT Name FROM institution ORDER BY Founded ASC

Question: Return the nickname of the institution with the lowest enrollment.
SQL: SELECT T1.Nickname FROM championship AS T1 JOIN institution AS T2 ON T1.Institution_ID  =  T2.Institution_ID ORDER BY T2.Enrollment ASC LIMIT 1

Question: What are the stadiums of institutions in descending order of the capacity.
SQL: SELECT Stadium FROM institution ORDER BY Capacity DESC

Question: What is the total number of championship of institution with public affiliation?
SQL: SELECT sum(T1.Number_of_Championships) FROM championship AS T1 JOIN institution AS T2 ON T1.Institution_ID  =  T2.Institution_ID WHERE T2.Affiliation  =  "Public"

Question: Return the total number of championships of institutions that have a Public affiliation.
SQL: SELECT sum(T1.Number_of_Championships) FROM championship AS T1 JOIN institution AS T2 ON T1.Institution_ID  =  T2.Institution_ID WHERE T2.Affiliation  =  "Public"

Question: Return the stadiums of institutions, ordered by capacity descending.
SQL: SELECT Stadium FROM institution ORDER BY Capacity DESC

Question: How many distinct provinces are the institutions in?
SQL: SELECT count(DISTINCT Province) FROM institution

Question: List the nicknames of institutions in descending order of capacity.
SQL: SELECT T1.Nickname FROM championship AS T1 JOIN institution AS T2 ON T1.Institution_ID  =  T2.Institution_ID ORDER BY T2.Capacity DESC

Question: What are the provinces that have not only institutions founded before 1920, but also institutions founded after 1950?
SQL: SELECT Province FROM institution WHERE Founded  <  1920 INTERSECT SELECT Province FROM institution WHERE Founded  >  1950

Question: What are the total enrollment of institutions in city `` Vancouver '' or `` Calgary '' ?
SQL: select sum(enrollment) from institution where city  =  "vancouver" or city  =  "calgary"

Question: What are the nicknames of institutions, ordered descending by their capacities?
SQL: SELECT T1.Nickname FROM championship AS T1 JOIN institution AS T2 ON T1.Institution_ID  =  T2.Institution_ID ORDER BY T2.Capacity DESC

Question: Return the years in which more than 1 institution was founded, as well as the number of institutions founded in each of those.
SQL: SELECT Founded ,  COUNT(*) FROM institution GROUP BY Founded HAVING COUNT(*)  >  1

Question: What is the stadium of the institution with the largest enrollment?
SQL: SELECT Stadium FROM institution ORDER BY Enrollment DESC LIMIT 1

Question: What are different types of affiliations of institutions and the corresponding number of institutions?
SQL: SELECT Affiliation ,  COUNT(*) FROM institution GROUP BY Affiliation

Question: List the names of institutions with at least one championship.
SQL: SELECT T2.Name FROM championship AS T1 JOIN institution AS T2 ON T1.Institution_ID  =  T2.Institution_ID WHERE T1.Number_of_Championships  >=  1

Question: What are the names of institutions, ordered alphabetically?
SQL: SELECT Name FROM institution ORDER BY Name ASC

Question: What are the maximum and minimum enrollment of all institutions?
SQL: SELECT max(Enrollment) ,  min(Enrollment) FROM institution

Question: What are the names of institutions that have 1 or more championships?
SQL: SELECT T2.Name FROM championship AS T1 JOIN institution AS T2 ON T1.Institution_ID  =  T2.Institution_ID WHERE T1.Number_of_Championships  >=  1

Question: Count the number of different provinces that have institutions.
SQL: SELECT count(DISTINCT Province) FROM institution

Question: What is the most common type of affiliation for institutions?
SQL: SELECT Affiliation FROM institution GROUP BY Affiliation ORDER BY COUNT(*) DESC LIMIT 1

Question: What is the nickname of the institution with the smallest enrollment?
SQL: SELECT T1.Nickname FROM championship AS T1 JOIN institution AS T2 ON T1.Institution_ID  =  T2.Institution_ID ORDER BY T2.Enrollment ASC LIMIT 1

Question: Return the names of institutions, as well as their nicknames.
SQL: SELECT T2.Name ,  T1.Nickname FROM championship AS T1 JOIN institution AS T2 ON T1.Institution_ID  =  T2.Institution_ID

Question: Return the most common type of affiliation across all institutions.
SQL: SELECT Affiliation FROM institution GROUP BY Affiliation ORDER BY COUNT(*) DESC LIMIT 1

Question: List the names of institutions in ascending alphabetical order.
SQL: SELECT Name FROM institution ORDER BY Name ASC