lianghsun/spider-text2sql-bench huggingface dataset:
### Database Schema
CREATE TABLE "driver" (
"Driver_ID" int,
"Name" text,
"Party" text,
"Home_city" text,
"Age" int,
PRIMARY KEY ("Driver_ID")
)

CREATE TABLE "school" (
"School_ID" int,
"Grade" text,
"School" text,
"Location" text,
"Type" text,
PRIMARY KEY ("School_ID")
)

CREATE TABLE "school_bus" (
"School_ID" int,
"Driver_ID" int,
"Years_Working" int,
"If_full_time" bool,
PRIMARY KEY ("School_ID","Driver_ID"),
FOREIGN KEY ("School_ID") REFERENCES `school`("School_ID"),
FOREIGN KEY ("Driver_ID") REFERENCES `driver`("Driver_ID")
)

### Question
How many drivers are from Hartford city or younger than 40?

### SQL
SELECT count(*) FROM driver WHERE home_city  =  'Hartford' OR age  <  40
### Database Schema
CREATE TABLE "driver" (
"Driver_ID" int,
"Name" text,
"Party" text,
"Home_city" text,
"Age" int,
PRIMARY KEY ("Driver_ID")
)

CREATE TABLE "school" (
"School_ID" int,
"Grade" text,
"School" text,
"Location" text,
"Type" text,
PRIMARY KEY ("School_ID")
)

CREATE TABLE "school_bus" (
"School_ID" int,
"Driver_ID" int,
"Years_Working" int,
"If_full_time" bool,
PRIMARY KEY ("School_ID","Driver_ID"),
FOREIGN KEY ("School_ID") REFERENCES `school`("School_ID"),
FOREIGN KEY ("Driver_ID") REFERENCES `driver`("Driver_ID")
)

### Question
List names for drivers from Hartford city and younger than 40.

### SQL
SELECT name FROM driver WHERE home_city  =  'Hartford' AND age  <  40
### Database Schema
CREATE TABLE "driver" (
"Driver_ID" int,
"Name" text,
"Party" text,
"Home_city" text,
"Age" int,
PRIMARY KEY ("Driver_ID")
)

CREATE TABLE "school" (
"School_ID" int,
"Grade" text,
"School" text,
"Location" text,
"Type" text,
PRIMARY KEY ("School_ID")
)

CREATE TABLE "school_bus" (
"School_ID" int,
"Driver_ID" int,
"Years_Working" int,
"If_full_time" bool,
PRIMARY KEY ("School_ID","Driver_ID"),
FOREIGN KEY ("School_ID") REFERENCES `school`("School_ID"),
FOREIGN KEY ("Driver_ID") REFERENCES `driver`("Driver_ID")
)

### Question
find the name of driver who is driving the school bus with the longest working history.

### SQL
SELECT t1.name FROM driver AS t1 JOIN school_bus AS t2 ON t1.driver_id  =  t2.driver_id ORDER BY years_working DESC LIMIT 1
### Database Schema
CREATE TABLE "airport" (
"id" int,
"City" text,
"Country" text,
"IATA" text,
"ICAO" text,
"name" text,
primary key("id")
)

CREATE TABLE "operate_company" (
"id" int,
"name" text,
"Type" text,
"Principal_activities" text,
"Incorporated_in" text,
"Group_Equity_Shareholding" real,
primary key ("id")
)

CREATE TABLE "flight" (
"id" int,
"Vehicle_Flight_number" text,
"Date" text,
"Pilot" text,
"Velocity" real,
"Altitude" real,
"airport_id" int,
"company_id" int,
primary key ("id"),
foreign key ("airport_id") references `airport`("id"),
foreign key ("company_id") references `operate_company`("id")
)

### Question
How many flights have a velocity larger than 200?

### SQL
SELECT count(*) FROM flight WHERE velocity  >  200
### Database Schema
CREATE TABLE "airport" (
"id" int,
"City" text,
"Country" text,
"IATA" text,
"ICAO" text,
"name" text,
primary key("id")
)

CREATE TABLE "operate_company" (
"id" int,
"name" text,
"Type" text,
"Principal_activities" text,
"Incorporated_in" text,
"Group_Equity_Shareholding" real,
primary key ("id")
)

CREATE TABLE "flight" (
"id" int,
"Vehicle_Flight_number" text,
"Date" text,
"Pilot" text,
"Velocity" real,
"Altitude" real,
"airport_id" int,
"company_id" int,
primary key ("id"),
foreign key ("airport_id") references `airport`("id"),
foreign key ("company_id") references `operate_company`("id")
)

### Question
List the vehicle flight number, date and pilot of all the flights, ordered by altitude.

### SQL
SELECT vehicle_flight_number ,  date ,  pilot FROM flight ORDER BY altitude ASC
### Database Schema
CREATE TABLE "airport" (
"id" int,
"City" text,
"Country" text,
"IATA" text,
"ICAO" text,
"name" text,
primary key("id")
)

CREATE TABLE "operate_company" (
"id" int,
"name" text,
"Type" text,
"Principal_activities" text,
"Incorporated_in" text,
"Group_Equity_Shareholding" real,
primary key ("id")
)

CREATE TABLE "flight" (
"id" int,
"Vehicle_Flight_number" text,
"Date" text,
"Pilot" text,
"Velocity" real,
"Altitude" real,
"airport_id" int,
"company_id" int,
primary key ("id"),
foreign key ("airport_id") references `airport`("id"),
foreign key ("company_id") references `operate_company`("id")
)

### Question
List the id, country, city and name of the airports ordered alphabetically by the name.

### SQL
SELECT id ,  country ,  city ,  name FROM airport ORDER BY name
### Database Schema
CREATE TABLE "airport" (
"id" int,
"City" text,
"Country" text,
"IATA" text,
"ICAO" text,
"name" text,
primary key("id")
)

CREATE TABLE "operate_company" (
"id" int,
"name" text,
"Type" text,
"Principal_activities" text,
"Incorporated_in" text,
"Group_Equity_Shareholding" real,
primary key ("id")
)

CREATE TABLE "flight" (
"id" int,
"Vehicle_Flight_number" text,
"Date" text,
"Pilot" text,
"Velocity" real,
"Altitude" real,
"airport_id" int,
"company_id" int,
primary key ("id"),
foreign key ("airport_id") references `airport`("id"),
foreign key ("company_id") references `operate_company`("id")
)

### Question
What is maximum group equity shareholding of the companies?

### SQL
SELECT max(group_equity_shareholding) FROM operate_company
### Database Schema
CREATE TABLE "airport" (
"id" int,
"City" text,
"Country" text,
"IATA" text,
"ICAO" text,
"name" text,
primary key("id")
)

CREATE TABLE "operate_company" (
"id" int,
"name" text,
"Type" text,
"Principal_activities" text,
"Incorporated_in" text,
"Group_Equity_Shareholding" real,
primary key ("id")
)

CREATE TABLE "flight" (
"id" int,
"Vehicle_Flight_number" text,
"Date" text,
"Pilot" text,
"Velocity" real,
"Altitude" real,
"airport_id" int,
"company_id" int,
primary key ("id"),
foreign key ("airport_id") references `airport`("id"),
foreign key ("company_id") references `operate_company`("id")
)

### Question
What is the velocity of the pilot named 'Thompson'?

### SQL
SELECT avg(velocity) FROM flight WHERE pilot  =  'Thompson'
### Database Schema
CREATE TABLE "airport" (
"id" int,
"City" text,
"Country" text,
"IATA" text,
"ICAO" text,
"name" text,
primary key("id")
)

CREATE TABLE "operate_company" (
"id" int,
"name" text,
"Type" text,
"Principal_activities" text,
"Incorporated_in" text,
"Group_Equity_Shareholding" real,
primary key ("id")
)

CREATE TABLE "flight" (
"id" int,
"Vehicle_Flight_number" text,
"Date" text,
"Pilot" text,
"Velocity" real,
"Altitude" real,
"airport_id" int,
"company_id" int,
primary key ("id"),
foreign key ("airport_id") references `airport`("id"),
foreign key ("company_id") references `operate_company`("id")
)

### Question
What are the names and types of the companies that have ever operated a flight?

### SQL
SELECT T1.name ,  T1.type FROM operate_company AS T1 JOIN flight AS t2 ON T1.id  =  T2.company_id
### Database Schema
CREATE TABLE "airport" (
"id" int,
"City" text,
"Country" text,
"IATA" text,
"ICAO" text,
"name" text,
primary key("id")
)

CREATE TABLE "operate_company" (
"id" int,
"name" text,
"Type" text,
"Principal_activities" text,
"Incorporated_in" text,
"Group_Equity_Shareholding" real,
primary key ("id")
)

CREATE TABLE "flight" (
"id" int,
"Vehicle_Flight_number" text,
"Date" text,
"Pilot" text,
"Velocity" real,
"Altitude" real,
"airport_id" int,
"company_id" int,
primary key ("id"),
foreign key ("airport_id") references `airport`("id"),
foreign key ("company_id") references `operate_company`("id")
)

### Question
What are the names of the airports which are not in the country 'Iceland'?

### SQL
SELECT name FROM airport WHERE country != 'Iceland'
### Database Schema
CREATE TABLE "airport" (
"id" int,
"City" text,
"Country" text,
"IATA" text,
"ICAO" text,
"name" text,
primary key("id")
)

CREATE TABLE "operate_company" (
"id" int,
"name" text,
"Type" text,
"Principal_activities" text,
"Incorporated_in" text,
"Group_Equity_Shareholding" real,
primary key ("id")
)

CREATE TABLE "flight" (
"id" int,
"Vehicle_Flight_number" text,
"Date" text,
"Pilot" text,
"Velocity" real,
"Altitude" real,
"airport_id" int,
"company_id" int,
primary key ("id"),
foreign key ("airport_id") references `airport`("id"),
foreign key ("company_id") references `operate_company`("id")
)

### Question
What are the distinct types of the companies that have operated any flights with velocity less than 200?

### SQL
SELECT DISTINCT T1.type FROM operate_company AS T1 JOIN flight AS t2 ON T1.id  =  T2.company_id WHERE T2.velocity  <  200
### Database Schema
CREATE TABLE "airport" (
"id" int,
"City" text,
"Country" text,
"IATA" text,
"ICAO" text,
"name" text,
primary key("id")
)

CREATE TABLE "operate_company" (
"id" int,
"name" text,
"Type" text,
"Principal_activities" text,
"Incorporated_in" text,
"Group_Equity_Shareholding" real,
primary key ("id")
)

CREATE TABLE "flight" (
"id" int,
"Vehicle_Flight_number" text,
"Date" text,
"Pilot" text,
"Velocity" real,
"Altitude" real,
"airport_id" int,
"company_id" int,
primary key ("id"),
foreign key ("airport_id") references `airport`("id"),
foreign key ("company_id") references `operate_company`("id")
)

### Question
What are the ids and names of the companies that operated more than one flight?

### SQL
SELECT T1.id ,  T1.name FROM operate_company AS T1 JOIN flight AS t2 ON T1.id  =  T2.company_id GROUP BY T1.id HAVING count(*)  >  1
### Database Schema
CREATE TABLE "airport" (
"id" int,
"City" text,
"Country" text,
"IATA" text,
"ICAO" text,
"name" text,
primary key("id")
)

CREATE TABLE "operate_company" (
"id" int,
"name" text,
"Type" text,
"Principal_activities" text,
"Incorporated_in" text,
"Group_Equity_Shareholding" real,
primary key ("id")
)

CREATE TABLE "flight" (
"id" int,
"Vehicle_Flight_number" text,
"Date" text,
"Pilot" text,
"Velocity" real,
"Altitude" real,
"airport_id" int,
"company_id" int,
primary key ("id"),
foreign key ("airport_id") references `airport`("id"),
foreign key ("company_id") references `operate_company`("id")
)

### Question
What is the id, name and IATA code of the airport that had most number of flights?

### SQL
SELECT T1.id ,  T1.name ,  T1.IATA FROM airport AS T1 JOIN flight AS T2 ON T1.id  =  T2.airport_id GROUP BY T2.id ORDER BY count(*) DESC LIMIT 1
### Database Schema
CREATE TABLE "airport" (
"id" int,
"City" text,
"Country" text,
"IATA" text,
"ICAO" text,
"name" text,
primary key("id")
)

CREATE TABLE "operate_company" (
"id" int,
"name" text,
"Type" text,
"Principal_activities" text,
"Incorporated_in" text,
"Group_Equity_Shareholding" real,
primary key ("id")
)

CREATE TABLE "flight" (
"id" int,
"Vehicle_Flight_number" text,
"Date" text,
"Pilot" text,
"Velocity" real,
"Altitude" real,
"airport_id" int,
"company_id" int,
primary key ("id"),
foreign key ("airport_id") references `airport`("id"),
foreign key ("company_id") references `operate_company`("id")
)

### Question
What are the different pilot names who had piloted a flight in the country 'United States' or in the airport named 'Billund Airport'?

### SQL
SELECT DISTINCT T2.pilot FROM airport AS T1 JOIN flight AS T2 ON T1.id  =  T2.airport_id WHERE T1.country  =  'United States' OR T1.name  =  'Billund Airport'
### Database Schema
CREATE TABLE "airport" (
"id" int,
"City" text,
"Country" text,
"IATA" text,
"ICAO" text,
"name" text,
primary key("id")
)

CREATE TABLE "operate_company" (
"id" int,
"name" text,
"Type" text,
"Principal_activities" text,
"Incorporated_in" text,
"Group_Equity_Shareholding" real,
primary key ("id")
)

CREATE TABLE "flight" (
"id" int,
"Vehicle_Flight_number" text,
"Date" text,
"Pilot" text,
"Velocity" real,
"Altitude" real,
"airport_id" int,
"company_id" int,
primary key ("id"),
foreign key ("airport_id") references `airport`("id"),
foreign key ("company_id") references `operate_company`("id")
)

### Question
What is the most common company type, and how many are there?

### SQL
SELECT TYPE ,  count(*) FROM operate_company GROUP BY TYPE ORDER BY count(*) DESC LIMIT 1
### Database Schema
CREATE TABLE "airport" (
"id" int,
"City" text,
"Country" text,
"IATA" text,
"ICAO" text,
"name" text,
primary key("id")
)

CREATE TABLE "operate_company" (
"id" int,
"name" text,
"Type" text,
"Principal_activities" text,
"Incorporated_in" text,
"Group_Equity_Shareholding" real,
primary key ("id")
)

CREATE TABLE "flight" (
"id" int,
"Vehicle_Flight_number" text,
"Date" text,
"Pilot" text,
"Velocity" real,
"Altitude" real,
"airport_id" int,
"company_id" int,
primary key ("id"),
foreign key ("airport_id") references `airport`("id"),
foreign key ("company_id") references `operate_company`("id")
)

### Question
How many airports haven't the pilot 'Thompson' driven an aircraft?

### SQL
SELECT count(*) FROM airport WHERE id NOT IN ( SELECT airport_id FROM flight WHERE pilot  =  'Thompson' );
### Database Schema
CREATE TABLE "airport" (
"id" int,
"City" text,
"Country" text,
"IATA" text,
"ICAO" text,
"name" text,
primary key("id")
)

CREATE TABLE "operate_company" (
"id" int,
"name" text,
"Type" text,
"Principal_activities" text,
"Incorporated_in" text,
"Group_Equity_Shareholding" real,
primary key ("id")
)

CREATE TABLE "flight" (
"id" int,
"Vehicle_Flight_number" text,
"Date" text,
"Pilot" text,
"Velocity" real,
"Altitude" real,
"airport_id" int,
"company_id" int,
primary key ("id"),
foreign key ("airport_id") references `airport`("id"),
foreign key ("company_id") references `operate_company`("id")
)

### Question
List the name of the pilots who have flied for both a company that mainly provide 'Cargo' services and a company that runs 'Catering services' activities.

### SQL
SELECT T2.pilot FROM operate_company AS T1 JOIN flight AS t2 ON T1.id  =  T2.company_id WHERE T1.principal_activities  =  'Cargo' INTERSECT SELECT T2.pilot FROM operate_company AS T1 JOIN flight AS t2 ON T1.id  =  T2.company_id WHERE T1.principal_activities  =  'Catering services'
### Database Schema
CREATE TABLE "airport" (
"id" int,
"City" text,
"Country" text,
"IATA" text,
"ICAO" text,
"name" text,
primary key("id")
)

CREATE TABLE "operate_company" (
"id" int,
"name" text,
"Type" text,
"Principal_activities" text,
"Incorporated_in" text,
"Group_Equity_Shareholding" real,
primary key ("id")
)

CREATE TABLE "flight" (
"id" int,
"Vehicle_Flight_number" text,
"Date" text,
"Pilot" text,
"Velocity" real,
"Altitude" real,
"airport_id" int,
"company_id" int,
primary key ("id"),
foreign key ("airport_id") references `airport`("id"),
foreign key ("company_id") references `operate_company`("id")
)

### Question
Which of the airport names contains the word 'international'?

### SQL
SELECT name FROM airport WHERE name LIKE '%international%'
### Database Schema
CREATE TABLE "airport" (
"id" int,
"City" text,
"Country" text,
"IATA" text,
"ICAO" text,
"name" text,
primary key("id")
)

CREATE TABLE "operate_company" (
"id" int,
"name" text,
"Type" text,
"Principal_activities" text,
"Incorporated_in" text,
"Group_Equity_Shareholding" real,
primary key ("id")
)

CREATE TABLE "flight" (
"id" int,
"Vehicle_Flight_number" text,
"Date" text,
"Pilot" text,
"Velocity" real,
"Altitude" real,
"airport_id" int,
"company_id" int,
primary key ("id"),
foreign key ("airport_id") references `airport`("id"),
foreign key ("company_id") references `operate_company`("id")
)

### Question
How many companies operates airlines in each airport?

### SQL
SELECT T3.id ,  count(*) FROM operate_company AS T1 JOIN flight AS t2 ON T1.id  =  T2.company_id JOIN airport AS T3 ON T2.airport_id  =  T3.id GROUP BY T3.id
### Database Schema
CREATE TABLE "airport" (
"id" int,
"City" text,
"Country" text,
"IATA" text,
"ICAO" text,
"name" text,
primary key("id")
)

CREATE TABLE "operate_company" (
"id" int,
"name" text,
"Type" text,
"Principal_activities" text,
"Incorporated_in" text,
"Group_Equity_Shareholding" real,
primary key ("id")
)

CREATE TABLE "flight" (
"id" int,
"Vehicle_Flight_number" text,
"Date" text,
"Pilot" text,
"Velocity" real,
"Altitude" real,
"airport_id" int,
"company_id" int,
primary key ("id"),
foreign key ("airport_id") references `airport`("id"),
foreign key ("company_id") references `operate_company`("id")
)

### Question
how many airports are there in each country?

### SQL
SELECT count(*) ,  country FROM airport GROUP BY country
### Database Schema
CREATE TABLE "airport" (
"id" int,
"City" text,
"Country" text,
"IATA" text,
"ICAO" text,
"name" text,
primary key("id")
)

CREATE TABLE "operate_company" (
"id" int,
"name" text,
"Type" text,
"Principal_activities" text,
"Incorporated_in" text,
"Group_Equity_Shareholding" real,
primary key ("id")
)

CREATE TABLE "flight" (
"id" int,
"Vehicle_Flight_number" text,
"Date" text,
"Pilot" text,
"Velocity" real,
"Altitude" real,
"airport_id" int,
"company_id" int,
primary key ("id"),
foreign key ("airport_id") references `airport`("id"),
foreign key ("company_id") references `operate_company`("id")
)

### Question
which countries have more than 2 airports?

### SQL
SELECT country FROM airport GROUP BY country HAVING count(*)  >  2
### Database Schema
CREATE TABLE "airport" (
"id" int,
"City" text,
"Country" text,
"IATA" text,
"ICAO" text,
"name" text,
primary key("id")
)

CREATE TABLE "operate_company" (
"id" int,
"name" text,
"Type" text,
"Principal_activities" text,
"Incorporated_in" text,
"Group_Equity_Shareholding" real,
primary key ("id")
)

CREATE TABLE "flight" (
"id" int,
"Vehicle_Flight_number" text,
"Date" text,
"Pilot" text,
"Velocity" real,
"Altitude" real,
"airport_id" int,
"company_id" int,
primary key ("id"),
foreign key ("airport_id") references `airport`("id"),
foreign key ("company_id") references `operate_company`("id")
)

### Question
which pilot is in charge of the most number of flights?

### SQL
SELECT pilot FROM flight GROUP BY pilot ORDER BY count(*) DESC LIMIT 1
### Database Schema
CREATE TABLE Ref_Document_Types (
Document_Type_Code CHAR(15) NOT NULL,
Document_Type_Name VARCHAR(255) NOT NULL,
Document_Type_Description VARCHAR(255) NOT NULL,
PRIMARY KEY (Document_Type_Code)
)

CREATE TABLE Ref_Budget_Codes (
Budget_Type_Code CHAR(15) NOT NULL,
Budget_Type_Description VARCHAR(255) NOT NULL,
PRIMARY KEY (Budget_Type_Code)
)

CREATE TABLE Projects (
Project_ID INTEGER NOT NULL,
Project_Details VARCHAR(255),
PRIMARY KEY (Project_ID)
)

CREATE TABLE Documents (
Document_ID INTEGER NOT NULL,
Document_Type_Code CHAR(15) NOT NULL,
Project_ID INTEGER NOT NULL,
Document_Date DATETIME,
Document_Name VARCHAR(255),
Document_Description VARCHAR(255),
Other_Details VARCHAR(255),
PRIMARY KEY (Document_ID),
FOREIGN KEY (Document_Type_Code) REFERENCES Ref_Document_Types (Document_Type_Code),
FOREIGN KEY (Project_ID) REFERENCES Projects (Project_ID)
)

CREATE TABLE Statements (
Statement_ID INTEGER NOT NULL,
Statement_Details VARCHAR(255),
PRIMARY KEY (Statement_ID),
FOREIGN KEY (Statement_ID) REFERENCES Documents (Document_ID)
)

CREATE TABLE Documents_with_Expenses (
Document_ID INTEGER NOT NULL,
Budget_Type_Code CHAR(15) NOT NULL,
Document_Details VARCHAR(255),
PRIMARY KEY (Document_ID),
FOREIGN KEY (Budget_Type_Code) REFERENCES Ref_Budget_Codes (Budget_Type_Code),
FOREIGN KEY (Document_ID) REFERENCES Documents (Document_ID)
)

CREATE TABLE Accounts (
Account_ID INTEGER NOT NULL,
Statement_ID INTEGER NOT NULL,
Account_Details VARCHAR(255),
PRIMARY KEY (Account_ID),
FOREIGN KEY (Statement_ID) REFERENCES Statements (Statement_ID)
)

### Question
How many accounts do we have?

### SQL
SELECT count(*) FROM Accounts
### Database Schema
CREATE TABLE Ref_Document_Types (
Document_Type_Code CHAR(15) NOT NULL,
Document_Type_Name VARCHAR(255) NOT NULL,
Document_Type_Description VARCHAR(255) NOT NULL,
PRIMARY KEY (Document_Type_Code)
)

CREATE TABLE Ref_Budget_Codes (
Budget_Type_Code CHAR(15) NOT NULL,
Budget_Type_Description VARCHAR(255) NOT NULL,
PRIMARY KEY (Budget_Type_Code)
)

CREATE TABLE Projects (
Project_ID INTEGER NOT NULL,
Project_Details VARCHAR(255),
PRIMARY KEY (Project_ID)
)

CREATE TABLE Documents (
Document_ID INTEGER NOT NULL,
Document_Type_Code CHAR(15) NOT NULL,
Project_ID INTEGER NOT NULL,
Document_Date DATETIME,
Document_Name VARCHAR(255),
Document_Description VARCHAR(255),
Other_Details VARCHAR(255),
PRIMARY KEY (Document_ID),
FOREIGN KEY (Document_Type_Code) REFERENCES Ref_Document_Types (Document_Type_Code),
FOREIGN KEY (Project_ID) REFERENCES Projects (Project_ID)
)

CREATE TABLE Statements (
Statement_ID INTEGER NOT NULL,
Statement_Details VARCHAR(255),
PRIMARY KEY (Statement_ID),
FOREIGN KEY (Statement_ID) REFERENCES Documents (Document_ID)
)

CREATE TABLE Documents_with_Expenses (
Document_ID INTEGER NOT NULL,
Budget_Type_Code CHAR(15) NOT NULL,
Document_Details VARCHAR(255),
PRIMARY KEY (Document_ID),
FOREIGN KEY (Budget_Type_Code) REFERENCES Ref_Budget_Codes (Budget_Type_Code),
FOREIGN KEY (Document_ID) REFERENCES Documents (Document_ID)
)

CREATE TABLE Accounts (
Account_ID INTEGER NOT NULL,
Statement_ID INTEGER NOT NULL,
Account_Details VARCHAR(255),
PRIMARY KEY (Account_ID),
FOREIGN KEY (Statement_ID) REFERENCES Statements (Statement_ID)
)

### Question
Count the number of accounts.

### SQL
SELECT count(*) FROM Accounts
### Database Schema
CREATE TABLE Ref_Document_Types (
Document_Type_Code CHAR(15) NOT NULL,
Document_Type_Name VARCHAR(255) NOT NULL,
Document_Type_Description VARCHAR(255) NOT NULL,
PRIMARY KEY (Document_Type_Code)
)

CREATE TABLE Ref_Budget_Codes (
Budget_Type_Code CHAR(15) NOT NULL,
Budget_Type_Description VARCHAR(255) NOT NULL,
PRIMARY KEY (Budget_Type_Code)
)

CREATE TABLE Projects (
Project_ID INTEGER NOT NULL,
Project_Details VARCHAR(255),
PRIMARY KEY (Project_ID)
)

CREATE TABLE Documents (
Document_ID INTEGER NOT NULL,
Document_Type_Code CHAR(15) NOT NULL,
Project_ID INTEGER NOT NULL,
Document_Date DATETIME,
Document_Name VARCHAR(255),
Document_Description VARCHAR(255),
Other_Details VARCHAR(255),
PRIMARY KEY (Document_ID),
FOREIGN KEY (Document_Type_Code) REFERENCES Ref_Document_Types (Document_Type_Code),
FOREIGN KEY (Project_ID) REFERENCES Projects (Project_ID)
)

CREATE TABLE Statements (
Statement_ID INTEGER NOT NULL,
Statement_Details VARCHAR(255),
PRIMARY KEY (Statement_ID),
FOREIGN KEY (Statement_ID) REFERENCES Documents (Document_ID)
)

CREATE TABLE Documents_with_Expenses (
Document_ID INTEGER NOT NULL,
Budget_Type_Code CHAR(15) NOT NULL,
Document_Details VARCHAR(255),
PRIMARY KEY (Document_ID),
FOREIGN KEY (Budget_Type_Code) REFERENCES Ref_Budget_Codes (Budget_Type_Code),
FOREIGN KEY (Document_ID) REFERENCES Documents (Document_ID)
)

CREATE TABLE Accounts (
Account_ID INTEGER NOT NULL,
Statement_ID INTEGER NOT NULL,
Account_Details VARCHAR(255),
PRIMARY KEY (Account_ID),
FOREIGN KEY (Statement_ID) REFERENCES Statements (Statement_ID)
)

### Question
Show all account ids and account details.

### SQL
SELECT account_id ,  account_details FROM Accounts
### Database Schema
CREATE TABLE Ref_Document_Types (
Document_Type_Code CHAR(15) NOT NULL,
Document_Type_Name VARCHAR(255) NOT NULL,
Document_Type_Description VARCHAR(255) NOT NULL,
PRIMARY KEY (Document_Type_Code)
)

CREATE TABLE Ref_Budget_Codes (
Budget_Type_Code CHAR(15) NOT NULL,
Budget_Type_Description VARCHAR(255) NOT NULL,
PRIMARY KEY (Budget_Type_Code)
)

CREATE TABLE Projects (
Project_ID INTEGER NOT NULL,
Project_Details VARCHAR(255),
PRIMARY KEY (Project_ID)
)

CREATE TABLE Documents (
Document_ID INTEGER NOT NULL,
Document_Type_Code CHAR(15) NOT NULL,
Project_ID INTEGER NOT NULL,
Document_Date DATETIME,
Document_Name VARCHAR(255),
Document_Description VARCHAR(255),
Other_Details VARCHAR(255),
PRIMARY KEY (Document_ID),
FOREIGN KEY (Document_Type_Code) REFERENCES Ref_Document_Types (Document_Type_Code),
FOREIGN KEY (Project_ID) REFERENCES Projects (Project_ID)
)

CREATE TABLE Statements (
Statement_ID INTEGER NOT NULL,
Statement_Details VARCHAR(255),
PRIMARY KEY (Statement_ID),
FOREIGN KEY (Statement_ID) REFERENCES Documents (Document_ID)
)

CREATE TABLE Documents_with_Expenses (
Document_ID INTEGER NOT NULL,
Budget_Type_Code CHAR(15) NOT NULL,
Document_Details VARCHAR(255),
PRIMARY KEY (Document_ID),
FOREIGN KEY (Budget_Type_Code) REFERENCES Ref_Budget_Codes (Budget_Type_Code),
FOREIGN KEY (Document_ID) REFERENCES Documents (Document_ID)
)

CREATE TABLE Accounts (
Account_ID INTEGER NOT NULL,
Statement_ID INTEGER NOT NULL,
Account_Details VARCHAR(255),
PRIMARY KEY (Account_ID),
FOREIGN KEY (Statement_ID) REFERENCES Statements (Statement_ID)
)

### Question
What are the ids and details of all accounts?

### SQL
SELECT account_id ,  account_details FROM Accounts
### Database Schema
CREATE TABLE Ref_Document_Types (
Document_Type_Code CHAR(15) NOT NULL,
Document_Type_Name VARCHAR(255) NOT NULL,
Document_Type_Description VARCHAR(255) NOT NULL,
PRIMARY KEY (Document_Type_Code)
)

CREATE TABLE Ref_Budget_Codes (
Budget_Type_Code CHAR(15) NOT NULL,
Budget_Type_Description VARCHAR(255) NOT NULL,
PRIMARY KEY (Budget_Type_Code)
)

CREATE TABLE Projects (
Project_ID INTEGER NOT NULL,
Project_Details VARCHAR(255),
PRIMARY KEY (Project_ID)
)

CREATE TABLE Documents (
Document_ID INTEGER NOT NULL,
Document_Type_Code CHAR(15) NOT NULL,
Project_ID INTEGER NOT NULL,
Document_Date DATETIME,
Document_Name VARCHAR(255),
Document_Description VARCHAR(255),
Other_Details VARCHAR(255),
PRIMARY KEY (Document_ID),
FOREIGN KEY (Document_Type_Code) REFERENCES Ref_Document_Types (Document_Type_Code),
FOREIGN KEY (Project_ID) REFERENCES Projects (Project_ID)
)

CREATE TABLE Statements (
Statement_ID INTEGER NOT NULL,
Statement_Details VARCHAR(255),
PRIMARY KEY (Statement_ID),
FOREIGN KEY (Statement_ID) REFERENCES Documents (Document_ID)
)

CREATE TABLE Documents_with_Expenses (
Document_ID INTEGER NOT NULL,
Budget_Type_Code CHAR(15) NOT NULL,
Document_Details VARCHAR(255),
PRIMARY KEY (Document_ID),
FOREIGN KEY (Budget_Type_Code) REFERENCES Ref_Budget_Codes (Budget_Type_Code),
FOREIGN KEY (Document_ID) REFERENCES Documents (Document_ID)
)

CREATE TABLE Accounts (
Account_ID INTEGER NOT NULL,
Statement_ID INTEGER NOT NULL,
Account_Details VARCHAR(255),
PRIMARY KEY (Account_ID),
FOREIGN KEY (Statement_ID) REFERENCES Statements (Statement_ID)
)

### Question
How many statements do we have?

### SQL
SELECT count(*) FROM Statements
### Database Schema
CREATE TABLE Ref_Document_Types (
Document_Type_Code CHAR(15) NOT NULL,
Document_Type_Name VARCHAR(255) NOT NULL,
Document_Type_Description VARCHAR(255) NOT NULL,
PRIMARY KEY (Document_Type_Code)
)

CREATE TABLE Ref_Budget_Codes (
Budget_Type_Code CHAR(15) NOT NULL,
Budget_Type_Description VARCHAR(255) NOT NULL,
PRIMARY KEY (Budget_Type_Code)
)

CREATE TABLE Projects (
Project_ID INTEGER NOT NULL,
Project_Details VARCHAR(255),
PRIMARY KEY (Project_ID)
)

CREATE TABLE Documents (
Document_ID INTEGER NOT NULL,
Document_Type_Code CHAR(15) NOT NULL,
Project_ID INTEGER NOT NULL,
Document_Date DATETIME,
Document_Name VARCHAR(255),
Document_Description VARCHAR(255),
Other_Details VARCHAR(255),
PRIMARY KEY (Document_ID),
FOREIGN KEY (Document_Type_Code) REFERENCES Ref_Document_Types (Document_Type_Code),
FOREIGN KEY (Project_ID) REFERENCES Projects (Project_ID)
)

CREATE TABLE Statements (
Statement_ID INTEGER NOT NULL,
Statement_Details VARCHAR(255),
PRIMARY KEY (Statement_ID),
FOREIGN KEY (Statement_ID) REFERENCES Documents (Document_ID)
)

CREATE TABLE Documents_with_Expenses (
Document_ID INTEGER NOT NULL,
Budget_Type_Code CHAR(15) NOT NULL,
Document_Details VARCHAR(255),
PRIMARY KEY (Document_ID),
FOREIGN KEY (Budget_Type_Code) REFERENCES Ref_Budget_Codes (Budget_Type_Code),
FOREIGN KEY (Document_ID) REFERENCES Documents (Document_ID)
)

CREATE TABLE Accounts (
Account_ID INTEGER NOT NULL,
Statement_ID INTEGER NOT NULL,
Account_Details VARCHAR(255),
PRIMARY KEY (Account_ID),
FOREIGN KEY (Statement_ID) REFERENCES Statements (Statement_ID)
)

### Question
Count the number of statements.

### SQL
SELECT count(*) FROM Statements
### Database Schema
CREATE TABLE Ref_Document_Types (
Document_Type_Code CHAR(15) NOT NULL,
Document_Type_Name VARCHAR(255) NOT NULL,
Document_Type_Description VARCHAR(255) NOT NULL,
PRIMARY KEY (Document_Type_Code)
)

CREATE TABLE Ref_Budget_Codes (
Budget_Type_Code CHAR(15) NOT NULL,
Budget_Type_Description VARCHAR(255) NOT NULL,
PRIMARY KEY (Budget_Type_Code)
)

CREATE TABLE Projects (
Project_ID INTEGER NOT NULL,
Project_Details VARCHAR(255),
PRIMARY KEY (Project_ID)
)

CREATE TABLE Documents (
Document_ID INTEGER NOT NULL,
Document_Type_Code CHAR(15) NOT NULL,
Project_ID INTEGER NOT NULL,
Document_Date DATETIME,
Document_Name VARCHAR(255),
Document_Description VARCHAR(255),
Other_Details VARCHAR(255),
PRIMARY KEY (Document_ID),
FOREIGN KEY (Document_Type_Code) REFERENCES Ref_Document_Types (Document_Type_Code),
FOREIGN KEY (Project_ID) REFERENCES Projects (Project_ID)
)

CREATE TABLE Statements (
Statement_ID INTEGER NOT NULL,
Statement_Details VARCHAR(255),
PRIMARY KEY (Statement_ID),
FOREIGN KEY (Statement_ID) REFERENCES Documents (Document_ID)
)

CREATE TABLE Documents_with_Expenses (
Document_ID INTEGER NOT NULL,
Budget_Type_Code CHAR(15) NOT NULL,
Document_Details VARCHAR(255),
PRIMARY KEY (Document_ID),
FOREIGN KEY (Budget_Type_Code) REFERENCES Ref_Budget_Codes (Budget_Type_Code),
FOREIGN KEY (Document_ID) REFERENCES Documents (Document_ID)
)

CREATE TABLE Accounts (
Account_ID INTEGER NOT NULL,
Statement_ID INTEGER NOT NULL,
Account_Details VARCHAR(255),
PRIMARY KEY (Account_ID),
FOREIGN KEY (Statement_ID) REFERENCES Statements (Statement_ID)
)

### Question
List all statement ids and statement details.

### SQL
SELECT STATEMENT_ID ,  statement_details FROM Statements
### Database Schema
CREATE TABLE Ref_Document_Types (
Document_Type_Code CHAR(15) NOT NULL,
Document_Type_Name VARCHAR(255) NOT NULL,
Document_Type_Description VARCHAR(255) NOT NULL,
PRIMARY KEY (Document_Type_Code)
)

CREATE TABLE Ref_Budget_Codes (
Budget_Type_Code CHAR(15) NOT NULL,
Budget_Type_Description VARCHAR(255) NOT NULL,
PRIMARY KEY (Budget_Type_Code)
)

CREATE TABLE Projects (
Project_ID INTEGER NOT NULL,
Project_Details VARCHAR(255),
PRIMARY KEY (Project_ID)
)

CREATE TABLE Documents (
Document_ID INTEGER NOT NULL,
Document_Type_Code CHAR(15) NOT NULL,
Project_ID INTEGER NOT NULL,
Document_Date DATETIME,
Document_Name VARCHAR(255),
Document_Description VARCHAR(255),
Other_Details VARCHAR(255),
PRIMARY KEY (Document_ID),
FOREIGN KEY (Document_Type_Code) REFERENCES Ref_Document_Types (Document_Type_Code),
FOREIGN KEY (Project_ID) REFERENCES Projects (Project_ID)
)

CREATE TABLE Statements (
Statement_ID INTEGER NOT NULL,
Statement_Details VARCHAR(255),
PRIMARY KEY (Statement_ID),
FOREIGN KEY (Statement_ID) REFERENCES Documents (Document_ID)
)

CREATE TABLE Documents_with_Expenses (
Document_ID INTEGER NOT NULL,
Budget_Type_Code CHAR(15) NOT NULL,
Document_Details VARCHAR(255),
PRIMARY KEY (Document_ID),
FOREIGN KEY (Budget_Type_Code) REFERENCES Ref_Budget_Codes (Budget_Type_Code),
FOREIGN KEY (Document_ID) REFERENCES Documents (Document_ID)
)

CREATE TABLE Accounts (
Account_ID INTEGER NOT NULL,
Statement_ID INTEGER NOT NULL,
Account_Details VARCHAR(255),
PRIMARY KEY (Account_ID),
FOREIGN KEY (Statement_ID) REFERENCES Statements (Statement_ID)
)

### Question
What are the ids and details of all statements?

### SQL
SELECT STATEMENT_ID ,  statement_details FROM Statements
### Database Schema
CREATE TABLE Ref_Document_Types (
Document_Type_Code CHAR(15) NOT NULL,
Document_Type_Name VARCHAR(255) NOT NULL,
Document_Type_Description VARCHAR(255) NOT NULL,
PRIMARY KEY (Document_Type_Code)
)

CREATE TABLE Ref_Budget_Codes (
Budget_Type_Code CHAR(15) NOT NULL,
Budget_Type_Description VARCHAR(255) NOT NULL,
PRIMARY KEY (Budget_Type_Code)
)

CREATE TABLE Projects (
Project_ID INTEGER NOT NULL,
Project_Details VARCHAR(255),
PRIMARY KEY (Project_ID)
)

CREATE TABLE Documents (
Document_ID INTEGER NOT NULL,
Document_Type_Code CHAR(15) NOT NULL,
Project_ID INTEGER NOT NULL,
Document_Date DATETIME,
Document_Name VARCHAR(255),
Document_Description VARCHAR(255),
Other_Details VARCHAR(255),
PRIMARY KEY (Document_ID),
FOREIGN KEY (Document_Type_Code) REFERENCES Ref_Document_Types (Document_Type_Code),
FOREIGN KEY (Project_ID) REFERENCES Projects (Project_ID)
)

CREATE TABLE Statements (
Statement_ID INTEGER NOT NULL,
Statement_Details VARCHAR(255),
PRIMARY KEY (Statement_ID),
FOREIGN KEY (Statement_ID) REFERENCES Documents (Document_ID)
)

CREATE TABLE Documents_with_Expenses (
Document_ID INTEGER NOT NULL,
Budget_Type_Code CHAR(15) NOT NULL,
Document_Details VARCHAR(255),
PRIMARY KEY (Document_ID),
FOREIGN KEY (Budget_Type_Code) REFERENCES Ref_Budget_Codes (Budget_Type_Code),
FOREIGN KEY (Document_ID) REFERENCES Documents (Document_ID)
)

CREATE TABLE Accounts (
Account_ID INTEGER NOT NULL,
Statement_ID INTEGER NOT NULL,
Account_Details VARCHAR(255),
PRIMARY KEY (Account_ID),
FOREIGN KEY (Statement_ID) REFERENCES Statements (Statement_ID)
)

### Question
Show statement id, statement detail, account detail for accounts.

### SQL
SELECT T1.statement_id ,  T2.statement_details ,  T1.account_details FROM Accounts AS T1 JOIN Statements AS T2 ON T1.statement_id  =  T2.statement_id
### Database Schema
CREATE TABLE Ref_Document_Types (
Document_Type_Code CHAR(15) NOT NULL,
Document_Type_Name VARCHAR(255) NOT NULL,
Document_Type_Description VARCHAR(255) NOT NULL,
PRIMARY KEY (Document_Type_Code)
)

CREATE TABLE Ref_Budget_Codes (
Budget_Type_Code CHAR(15) NOT NULL,
Budget_Type_Description VARCHAR(255) NOT NULL,
PRIMARY KEY (Budget_Type_Code)
)

CREATE TABLE Projects (
Project_ID INTEGER NOT NULL,
Project_Details VARCHAR(255),
PRIMARY KEY (Project_ID)
)

CREATE TABLE Documents (
Document_ID INTEGER NOT NULL,
Document_Type_Code CHAR(15) NOT NULL,
Project_ID INTEGER NOT NULL,
Document_Date DATETIME,
Document_Name VARCHAR(255),
Document_Description VARCHAR(255),
Other_Details VARCHAR(255),
PRIMARY KEY (Document_ID),
FOREIGN KEY (Document_Type_Code) REFERENCES Ref_Document_Types (Document_Type_Code),
FOREIGN KEY (Project_ID) REFERENCES Projects (Project_ID)
)

CREATE TABLE Statements (
Statement_ID INTEGER NOT NULL,
Statement_Details VARCHAR(255),
PRIMARY KEY (Statement_ID),
FOREIGN KEY (Statement_ID) REFERENCES Documents (Document_ID)
)

CREATE TABLE Documents_with_Expenses (
Document_ID INTEGER NOT NULL,
Budget_Type_Code CHAR(15) NOT NULL,
Document_Details VARCHAR(255),
PRIMARY KEY (Document_ID),
FOREIGN KEY (Budget_Type_Code) REFERENCES Ref_Budget_Codes (Budget_Type_Code),
FOREIGN KEY (Document_ID) REFERENCES Documents (Document_ID)
)

CREATE TABLE Accounts (
Account_ID INTEGER NOT NULL,
Statement_ID INTEGER NOT NULL,
Account_Details VARCHAR(255),
PRIMARY KEY (Account_ID),
FOREIGN KEY (Statement_ID) REFERENCES Statements (Statement_ID)
)

### Question
What are the statement ids, statement details, and account details, for all accounts?

### SQL
SELECT T1.statement_id ,  T2.statement_details ,  T1.account_details FROM Accounts AS T1 JOIN Statements AS T2 ON T1.statement_id  =  T2.statement_id
### Database Schema
CREATE TABLE Ref_Document_Types (
Document_Type_Code CHAR(15) NOT NULL,
Document_Type_Name VARCHAR(255) NOT NULL,
Document_Type_Description VARCHAR(255) NOT NULL,
PRIMARY KEY (Document_Type_Code)
)

CREATE TABLE Ref_Budget_Codes (
Budget_Type_Code CHAR(15) NOT NULL,
Budget_Type_Description VARCHAR(255) NOT NULL,
PRIMARY KEY (Budget_Type_Code)
)

CREATE TABLE Projects (
Project_ID INTEGER NOT NULL,
Project_Details VARCHAR(255),
PRIMARY KEY (Project_ID)
)

CREATE TABLE Documents (
Document_ID INTEGER NOT NULL,
Document_Type_Code CHAR(15) NOT NULL,
Project_ID INTEGER NOT NULL,
Document_Date DATETIME,
Document_Name VARCHAR(255),
Document_Description VARCHAR(255),
Other_Details VARCHAR(255),
PRIMARY KEY (Document_ID),
FOREIGN KEY (Document_Type_Code) REFERENCES Ref_Document_Types (Document_Type_Code),
FOREIGN KEY (Project_ID) REFERENCES Projects (Project_ID)
)

CREATE TABLE Statements (
Statement_ID INTEGER NOT NULL,
Statement_Details VARCHAR(255),
PRIMARY KEY (Statement_ID),
FOREIGN KEY (Statement_ID) REFERENCES Documents (Document_ID)
)

CREATE TABLE Documents_with_Expenses (
Document_ID INTEGER NOT NULL,
Budget_Type_Code CHAR(15) NOT NULL,
Document_Details VARCHAR(255),
PRIMARY KEY (Document_ID),
FOREIGN KEY (Budget_Type_Code) REFERENCES Ref_Budget_Codes (Budget_Type_Code),
FOREIGN KEY (Document_ID) REFERENCES Documents (Document_ID)
)

CREATE TABLE Accounts (
Account_ID INTEGER NOT NULL,
Statement_ID INTEGER NOT NULL,
Account_Details VARCHAR(255),
PRIMARY KEY (Account_ID),
FOREIGN KEY (Statement_ID) REFERENCES Statements (Statement_ID)
)

### Question
Show all statement id and the number of accounts for each statement.

### SQL
SELECT STATEMENT_ID ,  count(*) FROM Accounts GROUP BY STATEMENT_ID
### Database Schema
CREATE TABLE Ref_Document_Types (
Document_Type_Code CHAR(15) NOT NULL,
Document_Type_Name VARCHAR(255) NOT NULL,
Document_Type_Description VARCHAR(255) NOT NULL,
PRIMARY KEY (Document_Type_Code)
)

CREATE TABLE Ref_Budget_Codes (
Budget_Type_Code CHAR(15) NOT NULL,
Budget_Type_Description VARCHAR(255) NOT NULL,
PRIMARY KEY (Budget_Type_Code)
)

CREATE TABLE Projects (
Project_ID INTEGER NOT NULL,
Project_Details VARCHAR(255),
PRIMARY KEY (Project_ID)
)

CREATE TABLE Documents (
Document_ID INTEGER NOT NULL,
Document_Type_Code CHAR(15) NOT NULL,
Project_ID INTEGER NOT NULL,
Document_Date DATETIME,
Document_Name VARCHAR(255),
Document_Description VARCHAR(255),
Other_Details VARCHAR(255),
PRIMARY KEY (Document_ID),
FOREIGN KEY (Document_Type_Code) REFERENCES Ref_Document_Types (Document_Type_Code),
FOREIGN KEY (Project_ID) REFERENCES Projects (Project_ID)
)

CREATE TABLE Statements (
Statement_ID INTEGER NOT NULL,
Statement_Details VARCHAR(255),
PRIMARY KEY (Statement_ID),
FOREIGN KEY (Statement_ID) REFERENCES Documents (Document_ID)
)

CREATE TABLE Documents_with_Expenses (
Document_ID INTEGER NOT NULL,
Budget_Type_Code CHAR(15) NOT NULL,
Document_Details VARCHAR(255),
PRIMARY KEY (Document_ID),
FOREIGN KEY (Budget_Type_Code) REFERENCES Ref_Budget_Codes (Budget_Type_Code),
FOREIGN KEY (Document_ID) REFERENCES Documents (Document_ID)
)

CREATE TABLE Accounts (
Account_ID INTEGER NOT NULL,
Statement_ID INTEGER NOT NULL,
Account_Details VARCHAR(255),
PRIMARY KEY (Account_ID),
FOREIGN KEY (Statement_ID) REFERENCES Statements (Statement_ID)
)

### Question
What are the different statement ids on accounts, and the number of accounts for each?

### SQL
SELECT STATEMENT_ID ,  count(*) FROM Accounts GROUP BY STATEMENT_ID
### Database Schema
CREATE TABLE Ref_Document_Types (
Document_Type_Code CHAR(15) NOT NULL,
Document_Type_Name VARCHAR(255) NOT NULL,
Document_Type_Description VARCHAR(255) NOT NULL,
PRIMARY KEY (Document_Type_Code)
)

CREATE TABLE Ref_Budget_Codes (
Budget_Type_Code CHAR(15) NOT NULL,
Budget_Type_Description VARCHAR(255) NOT NULL,
PRIMARY KEY (Budget_Type_Code)
)

CREATE TABLE Projects (
Project_ID INTEGER NOT NULL,
Project_Details VARCHAR(255),
PRIMARY KEY (Project_ID)
)

CREATE TABLE Documents (
Document_ID INTEGER NOT NULL,
Document_Type_Code CHAR(15) NOT NULL,
Project_ID INTEGER NOT NULL,
Document_Date DATETIME,
Document_Name VARCHAR(255),
Document_Description VARCHAR(255),
Other_Details VARCHAR(255),
PRIMARY KEY (Document_ID),
FOREIGN KEY (Document_Type_Code) REFERENCES Ref_Document_Types (Document_Type_Code),
FOREIGN KEY (Project_ID) REFERENCES Projects (Project_ID)
)

CREATE TABLE Statements (
Statement_ID INTEGER NOT NULL,
Statement_Details VARCHAR(255),
PRIMARY KEY (Statement_ID),
FOREIGN KEY (Statement_ID) REFERENCES Documents (Document_ID)
)

CREATE TABLE Documents_with_Expenses (
Document_ID INTEGER NOT NULL,
Budget_Type_Code CHAR(15) NOT NULL,
Document_Details VARCHAR(255),
PRIMARY KEY (Document_ID),
FOREIGN KEY (Budget_Type_Code) REFERENCES Ref_Budget_Codes (Budget_Type_Code),
FOREIGN KEY (Document_ID) REFERENCES Documents (Document_ID)
)

CREATE TABLE Accounts (
Account_ID INTEGER NOT NULL,
Statement_ID INTEGER NOT NULL,
Account_Details VARCHAR(255),
PRIMARY KEY (Account_ID),
FOREIGN KEY (Statement_ID) REFERENCES Statements (Statement_ID)
)

### Question
Show the statement id and the statement detail for the statement with most number of accounts.

### SQL
SELECT T1.statement_id ,  T2.statement_details FROM Accounts AS T1 JOIN Statements AS T2 ON T1.statement_id  =  T2.statement_id GROUP BY T1.statement_id ORDER BY count(*) DESC LIMIT 1
### Database Schema
CREATE TABLE Ref_Document_Types (
Document_Type_Code CHAR(15) NOT NULL,
Document_Type_Name VARCHAR(255) NOT NULL,
Document_Type_Description VARCHAR(255) NOT NULL,
PRIMARY KEY (Document_Type_Code)
)

CREATE TABLE Ref_Budget_Codes (
Budget_Type_Code CHAR(15) NOT NULL,
Budget_Type_Description VARCHAR(255) NOT NULL,
PRIMARY KEY (Budget_Type_Code)
)

CREATE TABLE Projects (
Project_ID INTEGER NOT NULL,
Project_Details VARCHAR(255),
PRIMARY KEY (Project_ID)
)

CREATE TABLE Documents (
Document_ID INTEGER NOT NULL,
Document_Type_Code CHAR(15) NOT NULL,
Project_ID INTEGER NOT NULL,
Document_Date DATETIME,
Document_Name VARCHAR(255),
Document_Description VARCHAR(255),
Other_Details VARCHAR(255),
PRIMARY KEY (Document_ID),
FOREIGN KEY (Document_Type_Code) REFERENCES Ref_Document_Types (Document_Type_Code),
FOREIGN KEY (Project_ID) REFERENCES Projects (Project_ID)
)

CREATE TABLE Statements (
Statement_ID INTEGER NOT NULL,
Statement_Details VARCHAR(255),
PRIMARY KEY (Statement_ID),
FOREIGN KEY (Statement_ID) REFERENCES Documents (Document_ID)
)

CREATE TABLE Documents_with_Expenses (
Document_ID INTEGER NOT NULL,
Budget_Type_Code CHAR(15) NOT NULL,
Document_Details VARCHAR(255),
PRIMARY KEY (Document_ID),
FOREIGN KEY (Budget_Type_Code) REFERENCES Ref_Budget_Codes (Budget_Type_Code),
FOREIGN KEY (Document_ID) REFERENCES Documents (Document_ID)
)

CREATE TABLE Accounts (
Account_ID INTEGER NOT NULL,
Statement_ID INTEGER NOT NULL,
Account_Details VARCHAR(255),
PRIMARY KEY (Account_ID),
FOREIGN KEY (Statement_ID) REFERENCES Statements (Statement_ID)
)

### Question
What are the statement id and statement detail for the statement that has the most corresponding accounts?

### SQL
SELECT T1.statement_id ,  T2.statement_details FROM Accounts AS T1 JOIN Statements AS T2 ON T1.statement_id  =  T2.statement_id GROUP BY T1.statement_id ORDER BY count(*) DESC LIMIT 1
### Database Schema
CREATE TABLE Ref_Document_Types (
Document_Type_Code CHAR(15) NOT NULL,
Document_Type_Name VARCHAR(255) NOT NULL,
Document_Type_Description VARCHAR(255) NOT NULL,
PRIMARY KEY (Document_Type_Code)
)

CREATE TABLE Ref_Budget_Codes (
Budget_Type_Code CHAR(15) NOT NULL,
Budget_Type_Description VARCHAR(255) NOT NULL,
PRIMARY KEY (Budget_Type_Code)
)

CREATE TABLE Projects (
Project_ID INTEGER NOT NULL,
Project_Details VARCHAR(255),
PRIMARY KEY (Project_ID)
)

CREATE TABLE Documents (
Document_ID INTEGER NOT NULL,
Document_Type_Code CHAR(15) NOT NULL,
Project_ID INTEGER NOT NULL,
Document_Date DATETIME,
Document_Name VARCHAR(255),
Document_Description VARCHAR(255),
Other_Details VARCHAR(255),
PRIMARY KEY (Document_ID),
FOREIGN KEY (Document_Type_Code) REFERENCES Ref_Document_Types (Document_Type_Code),
FOREIGN KEY (Project_ID) REFERENCES Projects (Project_ID)
)

CREATE TABLE Statements (
Statement_ID INTEGER NOT NULL,
Statement_Details VARCHAR(255),
PRIMARY KEY (Statement_ID),
FOREIGN KEY (Statement_ID) REFERENCES Documents (Document_ID)
)

CREATE TABLE Documents_with_Expenses (
Document_ID INTEGER NOT NULL,
Budget_Type_Code CHAR(15) NOT NULL,
Document_Details VARCHAR(255),
PRIMARY KEY (Document_ID),
FOREIGN KEY (Budget_Type_Code) REFERENCES Ref_Budget_Codes (Budget_Type_Code),
FOREIGN KEY (Document_ID) REFERENCES Documents (Document_ID)
)

CREATE TABLE Accounts (
Account_ID INTEGER NOT NULL,
Statement_ID INTEGER NOT NULL,
Account_Details VARCHAR(255),
PRIMARY KEY (Account_ID),
FOREIGN KEY (Statement_ID) REFERENCES Statements (Statement_ID)
)

### Question
Show the number of documents.

### SQL
SELECT count(*) FROM Documents
### Database Schema
CREATE TABLE Ref_Document_Types (
Document_Type_Code CHAR(15) NOT NULL,
Document_Type_Name VARCHAR(255) NOT NULL,
Document_Type_Description VARCHAR(255) NOT NULL,
PRIMARY KEY (Document_Type_Code)
)

CREATE TABLE Ref_Budget_Codes (
Budget_Type_Code CHAR(15) NOT NULL,
Budget_Type_Description VARCHAR(255) NOT NULL,
PRIMARY KEY (Budget_Type_Code)
)

CREATE TABLE Projects (
Project_ID INTEGER NOT NULL,
Project_Details VARCHAR(255),
PRIMARY KEY (Project_ID)
)

CREATE TABLE Documents (
Document_ID INTEGER NOT NULL,
Document_Type_Code CHAR(15) NOT NULL,
Project_ID INTEGER NOT NULL,
Document_Date DATETIME,
Document_Name VARCHAR(255),
Document_Description VARCHAR(255),
Other_Details VARCHAR(255),
PRIMARY KEY (Document_ID),
FOREIGN KEY (Document_Type_Code) REFERENCES Ref_Document_Types (Document_Type_Code),
FOREIGN KEY (Project_ID) REFERENCES Projects (Project_ID)
)

CREATE TABLE Statements (
Statement_ID INTEGER NOT NULL,
Statement_Details VARCHAR(255),
PRIMARY KEY (Statement_ID),
FOREIGN KEY (Statement_ID) REFERENCES Documents (Document_ID)
)

CREATE TABLE Documents_with_Expenses (
Document_ID INTEGER NOT NULL,
Budget_Type_Code CHAR(15) NOT NULL,
Document_Details VARCHAR(255),
PRIMARY KEY (Document_ID),
FOREIGN KEY (Budget_Type_Code) REFERENCES Ref_Budget_Codes (Budget_Type_Code),
FOREIGN KEY (Document_ID) REFERENCES Documents (Document_ID)
)

CREATE TABLE Accounts (
Account_ID INTEGER NOT NULL,
Statement_ID INTEGER NOT NULL,
Account_Details VARCHAR(255),
PRIMARY KEY (Account_ID),
FOREIGN KEY (Statement_ID) REFERENCES Statements (Statement_ID)
)

### Question
Count the number of documents.

### SQL
SELECT count(*) FROM Documents
### Database Schema
CREATE TABLE Ref_Document_Types (
Document_Type_Code CHAR(15) NOT NULL,
Document_Type_Name VARCHAR(255) NOT NULL,
Document_Type_Description VARCHAR(255) NOT NULL,
PRIMARY KEY (Document_Type_Code)
)

CREATE TABLE Ref_Budget_Codes (
Budget_Type_Code CHAR(15) NOT NULL,
Budget_Type_Description VARCHAR(255) NOT NULL,
PRIMARY KEY (Budget_Type_Code)
)

CREATE TABLE Projects (
Project_ID INTEGER NOT NULL,
Project_Details VARCHAR(255),
PRIMARY KEY (Project_ID)
)

CREATE TABLE Documents (
Document_ID INTEGER NOT NULL,
Document_Type_Code CHAR(15) NOT NULL,
Project_ID INTEGER NOT NULL,
Document_Date DATETIME,
Document_Name VARCHAR(255),
Document_Description VARCHAR(255),
Other_Details VARCHAR(255),
PRIMARY KEY (Document_ID),
FOREIGN KEY (Document_Type_Code) REFERENCES Ref_Document_Types (Document_Type_Code),
FOREIGN KEY (Project_ID) REFERENCES Projects (Project_ID)
)

CREATE TABLE Statements (
Statement_ID INTEGER NOT NULL,
Statement_Details VARCHAR(255),
PRIMARY KEY (Statement_ID),
FOREIGN KEY (Statement_ID) REFERENCES Documents (Document_ID)
)

CREATE TABLE Documents_with_Expenses (
Document_ID INTEGER NOT NULL,
Budget_Type_Code CHAR(15) NOT NULL,
Document_Details VARCHAR(255),
PRIMARY KEY (Document_ID),
FOREIGN KEY (Budget_Type_Code) REFERENCES Ref_Budget_Codes (Budget_Type_Code),
FOREIGN KEY (Document_ID) REFERENCES Documents (Document_ID)
)

CREATE TABLE Accounts (
Account_ID INTEGER NOT NULL,
Statement_ID INTEGER NOT NULL,
Account_Details VARCHAR(255),
PRIMARY KEY (Account_ID),
FOREIGN KEY (Statement_ID) REFERENCES Statements (Statement_ID)
)

### Question
List the document type code, document name, and document description for the document with name 'Noel CV' or name 'King Book'.

### SQL
SELECT document_type_code ,  document_name ,  document_description FROM Documents WHERE document_name  =  'Noel CV' OR document_name  =  'King Book'