Database schema:
CREATE TABLE country (
  Country_Id NUMBER PRIMARY KEY,
  Country TEXT,
  Capital TEXT,
  Official_native_language TEXT,
  Regoin TEXT
);
CREATE TABLE team (
  Team_ID NUMBER PRIMARY KEY,
  Team TEXT,
  Make TEXT,
  Manager TEXT,
  Sponsor TEXT,
  Car_Owner TEXT
);
CREATE TABLE driver (
  Driver_ID NUMBER PRIMARY KEY,
  Driver TEXT,
  Country NUMBER,
  Age NUMBER,
  Car_# NUMBER,
  Make TEXT,
  Points TEXT,
  Laps NUMBER,
  Winnings TEXT
);
CREATE TABLE team_driver (
  Team_ID NUMBER PRIMARY KEY,
  Driver_ID NUMBER,
  FOREIGN KEY (Driver_ID) REFERENCES driver(Driver_ID),
  FOREIGN KEY (Team_ID) REFERENCES team(Team_ID)
);

Question: What is the average age of drivers from countries with official native language "English"
SQL: SELECT avg(T2.age) FROM country AS T1 JOIN driver AS T2 ON T1.Country_ID  =  T2.Country WHERE T1.Official_native_language  =  "English"

Question: List each make with the number of drivers with that make.
SQL: SELECT Make ,  COUNT(*) FROM driver GROUP BY Make

Question: Find the countries in which there are both drivers with make "Dodge" and drivers with make "Chevrolet".
SQL: SELECT t2.country FROM driver AS t1 JOIN country AS t2 ON t1.country  =  t2.country_id WHERE t1.Make  =  "Dodge" INTERSECT SELECT t2.country FROM driver AS t1 JOIN country AS t2 ON t1.country  =  t2.country_id WHERE t1.Make  =  "Chevrolet"

Question: What are the maximum and minimum points of drivers.
SQL: SELECT max(Points) ,  min(Points) FROM driver

Question: Find the highest and lowest points of drivers.
SQL: SELECT max(Points) ,  min(Points) FROM driver

Question: Count the number of drivers whose points are below 150.
SQL: SELECT count(*) FROM driver WHERE Points  <  150

Question: How many drivers receive points greater than 150 for each make? Show the make and the count.
SQL: SELECT make ,  count(*) FROM driver WHERE points  >  150 GROUP BY make

Question: List all the driver names in ascending order of age.
SQL: SELECT Driver FROM driver ORDER BY Age ASC

Question: Find all the countries where some drivers have points above 150.
SQL: SELECT T1.Country FROM country AS T1 JOIN driver AS T2 ON T1.Country_ID  =  T2.Country WHERE T2.Points  >  150

Question: What is the average age of drivers for each make? Return the average age and make.
SQL: SELECT avg(age) ,  Make FROM driver GROUP BY make

Question: Sort the driver names by age in ascending order.
SQL: SELECT Driver FROM driver ORDER BY Age ASC

Question: Which team does not have drivers?
SQL: SELECT Team FROM team WHERE Team_ID NOT IN (SELECT Team_ID FROM team_driver)

Question: What are the managers and sponsors of teams? Sort the results by Car Owners.
SQL: SELECT Manager ,  Sponsor FROM team ORDER BY Car_Owner

Question: Which make is associated with 3 or more drivers?
SQL: SELECT Make FROM driver GROUP BY Make HAVING COUNT(*)  >=  3

Question: List the make that are associated with most drivers.
SQL: SELECT Make FROM driver GROUP BY Make ORDER BY COUNT(*) DESC LIMIT 1

Question: What is the maximum points of the drivers from a country whose capital is "Dublin"?
SQL: SELECT max(T2.Points) FROM country AS T1 JOIN driver AS T2 ON T1.Country_ID  =  T2.Country WHERE T1.Capital  =  "Dublin"

Question: Find the manager and sponsor of the team that has the most drivers.
SQL: SELECT t1.manager ,  t1.sponsor FROM team AS t1 JOIN team_driver AS t2 ON t1.team_id  =  t2.team_id GROUP BY t2.team_id ORDER BY count(*) DESC LIMIT 1

Question: What are the total and average points of drivers?
SQL: SELECT sum(Points) ,  avg(Points) FROM driver

Question: What are the countries that have drivers with points larger than 150?
SQL: SELECT T1.Country FROM country AS T1 JOIN driver AS T2 ON T1.Country_ID  =  T2.Country WHERE T2.Points  >  150

Question: Find the countries where no driver come from.
SQL: SELECT country FROM country WHERE country_id NOT IN (SELECT country FROM driver)

Question: Which make does the most drivers have?
SQL: SELECT Make FROM driver GROUP BY Make ORDER BY COUNT(*) DESC LIMIT 1

Question: What is the list of drivers ordered by points in descending order?
SQL: SELECT Driver FROM driver ORDER BY Points DESC

Question: For each make, return the make and the count of drivers with that make.
SQL: SELECT Make ,  COUNT(*) FROM driver GROUP BY Make

Question: Find the total number of drivers.
SQL: SELECT count(*) FROM driver

Question: Find the average age of drivers for each make.
SQL: SELECT avg(age) ,  Make FROM driver GROUP BY make

Question: Find the average age of the drivers from the countries that use "English" as official native language.
SQL: SELECT avg(T2.age) FROM country AS T1 JOIN driver AS T2 ON T1.Country_ID  =  T2.Country WHERE T1.Official_native_language  =  "English"

Question: Which country is the driver with the highest points from? Give me the capital of the country.
SQL: SELECT T1.Capital FROM country AS T1 JOIN driver AS T2 ON T1.Country_ID  =  T2.Country ORDER BY T2.Points DESC LIMIT 1

Question: What are the makes of the teams with car owner "Buddy Arrington"?
SQL: SELECT Make FROM team WHERE Car_Owner  =  "Buddy Arrington"

Question: List the names of teams that do not have any drivers.
SQL: SELECT Team FROM team WHERE Team_ID NOT IN (SELECT Team_ID FROM team_driver)

Question: What are the manager and car owner of the team that has at least 2 drivers?
SQL: SELECT t1.manager ,  t1.car_owner FROM team AS t1 JOIN team_driver AS t2 ON t1.team_id  =  t2.team_id GROUP BY t2.team_id HAVING count(*)  >=  2

Question: Show the maximum points of the drivers from countries with capital "Dublin"
SQL: SELECT max(T2.Points) FROM country AS T1 JOIN driver AS T2 ON T1.Country_ID  =  T2.Country WHERE T1.Capital  =  "Dublin"

Question: Please show the names of drivers, and countries they are from.
SQL: SELECT T2.Driver ,  T1.Country FROM country AS T1 JOIN driver AS T2 ON T1.Country_ID  =  T2.Country

Question: What are the average laps of all the drivers who are younger than 20?
SQL: SELECT avg(Laps) FROM driver WHERE age  <  20

Question: For each driver, return his or her name and country.
SQL: SELECT T2.Driver ,  T1.Country FROM country AS T1 JOIN driver AS T2 ON T1.Country_ID  =  T2.Country

Question: Show total and average points of all drivers.
SQL: SELECT sum(Points) ,  avg(Points) FROM driver

Question: List all the driver names in descending order of points.
SQL: SELECT Driver FROM driver ORDER BY Points DESC

Question: Compute the average laps of drivers under the age of 20.
SQL: SELECT avg(Laps) FROM driver WHERE age  <  20

Question: Which country has both drivers with make "Dodge" and drivers with make "Chevrolet"?
SQL: SELECT t2.country FROM driver AS t1 JOIN country AS t2 ON t1.country  =  t2.country_id WHERE t1.Make  =  "Dodge" INTERSECT SELECT t2.country FROM driver AS t1 JOIN country AS t2 ON t1.country  =  t2.country_id WHERE t1.Make  =  "Chevrolet"

Question: What is the capital of the country where the driver with the most points is from?
SQL: SELECT T1.Capital FROM country AS T1 JOIN driver AS T2 ON T1.Country_ID  =  T2.Country ORDER BY T2.Points DESC LIMIT 1

Question: How many drivers have points smaller than 150?
SQL: SELECT count(*) FROM driver WHERE Points  <  150

Question: Find the manager and sponsor for each team and order them by the car owner.
SQL: SELECT Manager ,  Sponsor FROM team ORDER BY Car_Owner

Question: Find the make that has more than one team.
SQL: SELECT make FROM team GROUP BY team HAVING count(*)  >  1

Question: What are the manager and sponsor of the team that has the most drivers?
SQL: SELECT t1.manager ,  t1.sponsor FROM team AS t1 JOIN team_driver AS t2 ON t1.team_id  =  t2.team_id GROUP BY t2.team_id ORDER BY count(*) DESC LIMIT 1

Question: List the driver makes that are associated with at least three drivers.
SQL: SELECT Make FROM driver GROUP BY Make HAVING COUNT(*)  >=  3