Database schema:
CREATE TABLE Affiliation (
  affiliation_id NUMBER PRIMARY KEY,
  name TEXT,
  address TEXT
);
CREATE TABLE Author (
  author_id NUMBER PRIMARY KEY,
  name TEXT,
  email TEXT
);
CREATE TABLE Author_list (
  paper_id TEXT PRIMARY KEY,
  author_id NUMBER,
  affiliation_id NUMBER,
  FOREIGN KEY (affiliation_id) REFERENCES Affiliation(affiliation_id),
  FOREIGN KEY (author_id) REFERENCES Author(author_id),
  FOREIGN KEY (paper_id) REFERENCES Paper(paper_id)
);
CREATE TABLE Citation (
  paper_id TEXT PRIMARY KEY,
  cited_paper_id TEXT,
  FOREIGN KEY (cited_paper_id) REFERENCES Paper(paper_id),
  FOREIGN KEY (paper_id) REFERENCES Paper(paper_id)
);
CREATE TABLE Paper (
  paper_id TEXT PRIMARY KEY,
  title TEXT,
  venue TEXT,
  year NUMBER
);

Question: What are the distinct venues for papers, ordered by year?
SQL: SELECT DISTINCT venue ,  YEAR FROM paper ORDER BY YEAR

Question: How many papers cite paper with id A00-1002?
SQL: SELECT count(*) FROM Citation WHERE cited_paper_id  =  "A00-1002"

Question: What are the titles and paper ids for papers written in affiliation with Harvard University?
SQL: SELECT DISTINCT T1.title ,  T1.paper_id FROM Paper AS T1 JOIN Author_list AS T2 ON T1.paper_id  =  T2.paper_id JOIN Affiliation AS T3 ON T2.affiliation_id  =  T3.affiliation_id WHERE T3.name  =  "Harvard University"

Question: What are the titles and paper ids which have Mckeown as an author, but not Rambow?
SQL: SELECT T1.title ,  T1.paper_id FROM Paper AS T1 JOIN Author_list AS T2 ON T1.paper_id  =  T2.paper_id JOIN Author AS T3 ON T2.author_id  =  T3.author_id WHERE T3.name LIKE "%Mckeown%" EXCEPT SELECT T1.title ,  T1.paper_id FROM Paper AS T1 JOIN Author_list AS T2 ON T1.paper_id  =  T2.paper_id JOIN Author AS T3 ON T2.author_id  =  T3.author_id WHERE T3.name LIKE "%Rambow%"

Question: Find the name and number of citations of the author who has most citations among all authors?
SQL: SELECT T3.name ,  count(*) FROM Citation AS T1 JOIN Author_list AS T2 ON T1.cited_paper_id  =  T2.paper_id JOIN Author AS T3 ON T2.author_id  =  T3.author_id GROUP BY T2.author_id ORDER BY count(*) DESC LIMIT 1

Question: Find all papers with titles and paper IDs co-authored by Mckeown, Kathleen and Rambow, Owen.
SQL: SELECT T1.title ,  T1.paper_id FROM Paper AS T1 JOIN Author_list AS T2 ON T1.paper_id  =  T2.paper_id JOIN Author AS T3 ON T2.author_id  =  T3.author_id WHERE T3.name LIKE "%Mckeown ,  Kathleen%" INTERSECT SELECT T1.title ,  T1.paper_id FROM Paper AS T1 JOIN Author_list AS T2 ON T1.paper_id  =  T2.paper_id JOIN Author AS T3 ON T2.author_id  =  T3.author_id WHERE T3.name LIKE "%Rambow ,  Owen%"

Question: How many papers does Mckeown , Kathleen cite ?
SQL: select count(*) from citation as t1 join author_list as t2 on t1.paper_id  =  t2.paper_id join author as t3 on t2.author_id  =  t3.author_id where t3.name = "mckeown ,  kathleen"

Question: What are the names and addresses for all affiliations?
SQL: SELECT DISTINCT name ,  address FROM Affiliation

Question: Count the number of papers in NAACL 2000.
SQL: SELECT count(*) FROM Paper WHERE venue  =  "NAACL" AND YEAR  =  2000

Question: What is the id and the number of citations of the most cited paper?
SQL: SELECT paper_id ,  count(*) FROM Citation GROUP BY cited_paper_id ORDER BY count(*) DESC LIMIT 1

Question: How many papers do we have?
SQL: SELECT count(*) FROM Paper