target-benchmark/spider-queries huggingface dataset:
Database: headphone_store (tables: store)
Question: List name and parking info for the stores in the Tarzana neighborhood.
SQL: SELECT name ,  parking FROM store WHERE neighborhood  =  'Tarzana'
Database: headphone_store (tables: store)
Question: Which stores are located in the "Tarzana" neighborhood? Return their names and parking information.
SQL: SELECT name ,  parking FROM store WHERE neighborhood  =  'Tarzana'
Database: headphone_store (tables: store)
Question: How many different neighborhoods are there for all stores?
SQL: SELECT count(DISTINCT neighborhood) FROM store
Database: headphone_store (tables: store)
Question: Count the number of distinct neighborhoods stores are located.
SQL: SELECT count(DISTINCT neighborhood) FROM store
Database: headphone_store (tables: store)
Question: find the number of stores in each neighborhood.
SQL: SELECT count(*) ,  neighborhood FROM store GROUP BY neighborhood
Database: headphone_store (tables: store)
Question: How many stores are there in each neighborhood?
SQL: SELECT count(*) ,  neighborhood FROM store GROUP BY neighborhood
Database: headphone_store (tables: stock, store)
Question: Find the name of the store which has the most headphones in stock. List the number of headphones as well.
SQL: SELECT t1.name ,  sum(t2.quantity) FROM store AS t1 JOIN stock AS t2 ON t1.store_id  =  t2.store_id GROUP BY t2.store_id ORDER BY sum(t2.quantity) DESC LIMIT 1
Database: headphone_store (tables: stock, store)
Question: Which store has the headphones in stock? Give me the store name and the total quantity.
SQL: SELECT t1.name ,  sum(t2.quantity) FROM store AS t1 JOIN stock AS t2 ON t1.store_id  =  t2.store_id GROUP BY t2.store_id ORDER BY sum(t2.quantity) DESC LIMIT 1
Database: headphone_store (tables: stock, store)
Question: Find the name of stores which have no headphone in stock.
SQL: SELECT name FROM store WHERE store_id NOT IN (SELECT store_id FROM stock)
Database: headphone_store (tables: stock, store)
Question: Which stores do not have any headphones in stock? Give me the store names.
SQL: SELECT name FROM store WHERE store_id NOT IN (SELECT store_id FROM stock)
Database: headphone_store (tables: stock, headphone)
Question: Which headphone models do not have any stock in any store?
SQL: SELECT model FROM headphone WHERE headphone_id NOT IN (SELECT headphone_id FROM stock)
Database: headphone_store (tables: stock, headphone)
Question: Find the headphone models that are not in stock in any store.
SQL: SELECT model FROM headphone WHERE headphone_id NOT IN (SELECT headphone_id FROM stock)
Database: headphone_store (tables: stock, headphone)
Question: Which headphone model has the largest quantity of stock across all the stores?
SQL: SELECT t1.model FROM headphone AS t1 JOIN stock AS t2 ON t1.headphone_id  =  t2.headphone_id GROUP BY t1.model ORDER BY sum(t2.quantity) DESC LIMIT 1
Database: headphone_store (tables: stock, headphone)
Question: Find the headphone model whose total quantity in stock is the largest.
SQL: SELECT t1.model FROM headphone AS t1 JOIN stock AS t2 ON t1.headphone_id  =  t2.headphone_id GROUP BY t1.model ORDER BY sum(t2.quantity) DESC LIMIT 1
Database: headphone_store (tables: stock, store)
Question: How many headphones are stored in the Woodman store?
SQL: SELECT sum(t2.quantity) FROM store AS t1 JOIN stock AS t2 ON t1.store_id  =  t2.store_id WHERE t1.name  =  'Woodman'
Database: headphone_store (tables: stock, store)
Question: Find the total quantity of headphones stored in the Woodman store.
SQL: SELECT sum(t2.quantity) FROM store AS t1 JOIN stock AS t2 ON t1.store_id  =  t2.store_id WHERE t1.name  =  'Woodman'
Database: headphone_store (tables: stock, store)
Question: Which neighborhood does not have any headphone in stock?
SQL: SELECT Neighborhood FROM store EXCEPT SELECT t1.Neighborhood FROM store AS t1 JOIN stock AS t2 ON t1.store_id  =  t2.store_id
Database: headphone_store (tables: stock, store)
Question: Find the neighborhood where no headphones are in stock.
SQL: SELECT Neighborhood FROM store EXCEPT SELECT t1.Neighborhood FROM store AS t1 JOIN stock AS t2 ON t1.store_id  =  t2.store_id
Database: aan_1 (tables: author)
Question: How many authors do we have?
SQL: SELECT count(*) FROM Author
Database: aan_1 (tables: author)
Question: Count the number of authors.
SQL: SELECT count(*) FROM Author
Database: aan_1 (tables: paper)
Question: How many papers do we have?
SQL: SELECT count(*) FROM Paper
Database: aan_1 (tables: paper)
Question: Count the number of papers.
SQL: SELECT count(*) FROM Paper
Database: aan_1 (tables: affiliation)
Question: How many affiliations do we have?
SQL: SELECT count(*) FROM Affiliation
Database: aan_1 (tables: affiliation)
Question: Count the number of affiliations.
SQL: SELECT count(*) FROM Affiliation
Database: aan_1 (tables: paper)
Question: How many papers do we have in NAACL 2000?
SQL: SELECT count(*) FROM Paper WHERE venue  =  "NAACL" AND YEAR  =  2000
Database: aan_1 (tables: paper)
Question: Count the number of papers in NAACL 2000.
SQL: SELECT count(*) FROM Paper WHERE venue  =  "NAACL" AND YEAR  =  2000
Database: aan_1 (tables: paper, author_list, affiliation)
Question: How many papers are published in year 2009 by Columbia University?
SQL: SELECT count(DISTINCT 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 LIKE "Columbia University" AND T1.year  =  2009
Database: aan_1 (tables: paper, author_list, affiliation)
Question: Count the number of papers published by Columbia University in 2009.
SQL: SELECT count(DISTINCT 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 LIKE "Columbia University" AND T1.year  =  2009
Database: aan_1 (tables: affiliation)
Question: List names and addresses for all affiliations.
SQL: SELECT DISTINCT name ,  address FROM Affiliation
Database: aan_1 (tables: affiliation)
Question: What are the names and addresses for all affiliations?
SQL: SELECT DISTINCT name ,  address FROM Affiliation
Database: aan_1 (tables: paper)
Question: List all venues and years for papers ordered by year.
SQL: SELECT DISTINCT venue ,  YEAR FROM paper ORDER BY YEAR
Database: aan_1 (tables: paper)
Question: What are the distinct venues for papers, ordered by year?
SQL: SELECT DISTINCT venue ,  YEAR FROM paper ORDER BY YEAR
Database: aan_1 (tables: paper, author_list, affiliation)
Question: Find the titles and paper IDs for papers written by 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"
Database: aan_1 (tables: paper, author_list, affiliation)
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"
Database: aan_1 (tables: author, paper, author_list)
Question: Find all papers with titles and paper IDs written by Mckeown.
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 T3.author_id  =  T2.author_id WHERE T3.name LIKE "%Mckeown%"
Database: aan_1 (tables: author, paper, author_list)
Question: What are the titles and paper ids for papers written by Mckeown?
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 T3.author_id  =  T2.author_id WHERE T3.name LIKE "%Mckeown%"
Database: aan_1 (tables: paper, author_list, affiliation)
Question: Find all papers with titles and paper IDs collaborated by Stanford University and Columbia University.
SQL: SELECT 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 LIKE "Stanford University" INTERSECT SELECT 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 LIKE "Columbia University"
Database: aan_1 (tables: paper, author_list, affiliation)
Question: What are the titles and paper ids for papers which were affiliated with both Stanford and Columbia University?
SQL: SELECT 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 LIKE "Stanford University" INTERSECT SELECT 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 LIKE "Columbia University"
Database: aan_1 (tables: author, paper, author_list)
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%"
Database: aan_1 (tables: author, paper, author_list)
Question: What are the 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%"
Database: aan_1 (tables: author, paper, author_list)
Question: Find the titles and paper IDs for papers which have Mckeown but not Rambow in author list.
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%"
Database: aan_1 (tables: author, paper, author_list)
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%"
Database: aan_1 (tables: author, paper, author_list)
Question: Find the titles and paper IDs for papers which have Mckeown, Kathleen or Rambow, Owen in author list.
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 Author AS T3 ON T2.author_id  =  T3.author_id WHERE  T3.name LIKE "%Mckeown ,  Kathleen%" OR T3.name LIKE "%Rambow ,  Owen%"
Database: aan_1 (tables: author, paper, author_list)
Question: What are the titles and paper ids for papers that have Mckeown, Kathleen or Rambow, Owen in their author list?
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 Author AS T3 ON T2.author_id  =  T3.author_id WHERE  T3.name LIKE "%Mckeown ,  Kathleen%" OR T3.name LIKE "%Rambow ,  Owen%"
Database: aan_1 (tables: author, author_list)
Question: List the names of all authors and their number of papers in descending order by number of papers.
SQL: SELECT T1.name ,  count(*) FROM Author AS T1 JOIN Author_list AS T2 ON T1.author_id  =  T2.author_id GROUP BY T1.author_id ORDER BY count(*) DESC
Database: aan_1 (tables: author, author_list)
Question: How many papers did each author publish, ordered by number of papers?
SQL: SELECT T1.name ,  count(*) FROM Author AS T1 JOIN Author_list AS T2 ON T1.author_id  =  T2.author_id GROUP BY T1.author_id ORDER BY count(*) DESC
Database: aan_1 (tables: author_list, affiliation)
Question: List all affiliations with ascending ordered number of papers.
SQL: SELECT T1.name FROM Affiliation AS T1 JOIN Author_list AS T2 ON T1.affiliation_id  =  T2.affiliation_id GROUP BY T1.affiliation_id ORDER BY count(*) DESC
Database: aan_1 (tables: author_list, affiliation)
Question: What are the names of all affiliations, ordered by number of papers?
SQL: SELECT T1.name FROM Affiliation AS T1 JOIN Author_list AS T2 ON T1.affiliation_id  =  T2.affiliation_id GROUP BY T1.affiliation_id ORDER BY count(*) DESC
Database: aan_1 (tables: author, author_list)
Question: List names of all authors who have more than 50 papers.
SQL: SELECT T1.name FROM Author AS T1 JOIN Author_list AS T2 ON T1.author_id  =  T2.author_id GROUP BY T1.author_id HAVING count(*)  >  50
Database: aan_1 (tables: author, author_list)
Question: What are the names of all authors who have more than 50 papers?
SQL: SELECT T1.name FROM Author AS T1 JOIN Author_list AS T2 ON T1.author_id  =  T2.author_id GROUP BY T1.author_id HAVING count(*)  >  50
Database: aan_1 (tables: author, author_list)
Question: List names of all authors who have only 1 paper.
SQL: SELECT T1.name FROM Author AS T1 JOIN Author_list AS T2 ON T1.author_id  =  T2.author_id GROUP BY T1.author_id HAVING count(*)  =  1
Database: aan_1 (tables: author, author_list)
Question: What are the names of authors who have exactly 1 paper?
SQL: SELECT T1.name FROM Author AS T1 JOIN Author_list AS T2 ON T1.author_id  =  T2.author_id GROUP BY T1.author_id HAVING count(*)  =  1
Database: aan_1 (tables: paper)
Question: What is the venue and year with the most number of publications?
SQL: SELECT venue ,  YEAR FROM paper GROUP BY venue ,  YEAR ORDER BY count(*) DESC LIMIT 1
Database: aan_1 (tables: paper)
Question: What was the venue and year with the most publications?
SQL: SELECT venue ,  YEAR FROM paper GROUP BY venue ,  YEAR ORDER BY count(*) DESC LIMIT 1
Database: aan_1 (tables: paper)
Question: What is the venue with the least number of publications?
SQL: SELECT venue FROM paper GROUP BY venue ORDER BY count(*) LIMIT 1
Database: aan_1 (tables: paper)
Question: Which venue has the fewest publications?
SQL: SELECT venue FROM paper GROUP BY venue ORDER BY count(*) LIMIT 1
Database: aan_1 (tables: citation)
Question: How many papers cite paper with id A00-1002?
SQL: SELECT count(*) FROM Citation WHERE cited_paper_id  =  "A00-1002"
Database: aan_1 (tables: citation)
Question: Count the number of papers which cited a paper with id A00-1002.
SQL: SELECT count(*) FROM Citation WHERE cited_paper_id  =  "A00-1002"
Database: aan_1 (tables: citation)
Question: How many reference papers does paper with id D12-1027 have?
SQL: SELECT count(*) FROM Citation WHERE paper_id  =  "D12-1027"
Database: aan_1 (tables: citation)
Question: Count the number of references the paper with id D12-1027 has.
SQL: SELECT count(*) FROM Citation WHERE paper_id  =  "D12-1027"
Database: aan_1 (tables: citation)
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
Database: aan_1 (tables: citation)
Question: Give 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
Database: aan_1 (tables: paper, citation)
Question: Give the title of the paper which cites most number of papers?
SQL: SELECT T2.title FROM Citation AS T1 JOIN Paper AS T2 ON T2.paper_id  =  T1.paper_id GROUP BY T1.paper_id ORDER BY count(*) DESC LIMIT 1
Database: aan_1 (tables: paper, citation)
Question: What is the title of the paper which cites the most other papers?
SQL: SELECT T2.title FROM Citation AS T1 JOIN Paper AS T2 ON T2.paper_id  =  T1.paper_id GROUP BY T1.paper_id ORDER BY count(*) DESC LIMIT 1
Database: aan_1 (tables: citation)
Question: List top 10 most cited papers and their numbers of citations.
SQL: SELECT paper_id ,  count(*) FROM Citation GROUP BY cited_paper_id ORDER BY count(*) DESC LIMIT 10
Database: aan_1 (tables: citation)
Question: What are the 10 most cited papers, and how many citations did each have?
SQL: SELECT paper_id ,  count(*) FROM Citation GROUP BY cited_paper_id ORDER BY count(*) DESC LIMIT 10
Database: aan_1 (tables: author, citation, author_list)
Question: How many citations does Mckeown , Kathleen have ?
SQL: select 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 where t3.name = "mckeown ,  kathleen"
Database: aan_1 (tables: author, citation, author_list)
Question: Count the number of citations Mckeown , Kathleen has .
SQL: select 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 where t3.name = "mckeown ,  kathleen"
Database: aan_1 (tables: author, citation, author_list)
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"
Database: aan_1 (tables: author, citation, author_list)
Question: Count the number of papers Mckeown , Kathleen has cited .
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"
Database: aan_1 (tables: author, author_list, citation)
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
Database: aan_1 (tables: author, author_list, citation)
Question: What is the name and number of citations of the author with the greatest number of citations among 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
Database: aan_1 (tables: author, paper, author_list)
Question: What are the venues and years where Mckeown , Kathleen had papers ?
SQL: select distinct t1.venue ,  t1.year 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 = "mckeown ,  kathleen"
Database: aan_1 (tables: author, paper, author_list)
Question: Which venues and years did Mckeown , Kathleen have papers ?
SQL: select distinct t1.venue ,  t1.year 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 = "mckeown ,  kathleen"
Database: aan_1 (tables: paper, affiliation, author_list)
Question: What are the venues and years where Columbia University had papers ?
SQL: select distinct t1.venue ,  t1.year 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 = "columbia university"
Database: aan_1 (tables: paper, affiliation, author_list)
Question: Which venues and years did Columbia University have papers ?
SQL: select distinct t1.venue ,  t1.year 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 = "columbia university"
Database: aan_1 (tables: author, paper, author_list)
Question: Which author had the most papers in the year 2009?
SQL: SELECT T3.name FROM Paper AS T1 JOIN Author_list AS T2 ON T1.paper_id  =  T2.paper_id JOIN Author AS T3 ON T3.author_id  =  T2.author_id WHERE T1.year  =  2009 GROUP BY T2.author_id ORDER BY count(*) DESC LIMIT 1
Database: aan_1 (tables: author, paper, author_list)
Question: What is the name of the author with the most papers in 2009?
SQL: SELECT T3.name FROM Paper AS T1 JOIN Author_list AS T2 ON T1.paper_id  =  T2.paper_id JOIN Author AS T3 ON T3.author_id  =  T2.author_id WHERE T1.year  =  2009 GROUP BY T2.author_id ORDER BY count(*) DESC LIMIT 1
Database: aan_1 (tables: paper, author_list, affiliation)
Question: What are the names of the top 3 affiliations that have the most papers in year 2009?
SQL: SELECT T3.name 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 T1.year  =  2009 GROUP BY T2.affiliation_id ORDER BY count(*) DESC LIMIT 3
Database: aan_1 (tables: paper, author_list, affiliation)
Question: Which 3 affiliations had the most papers in 2009?
SQL: SELECT T3.name 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 T1.year  =  2009 GROUP BY T2.affiliation_id ORDER BY count(*) DESC LIMIT 3
Database: aan_1 (tables: paper, affiliation, author_list)
Question: How many papers does Columbia University have in or before 2009 ?
SQL: select count(distinct 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 t1.year  <=  2009 and t3.name = "columbia university"
Database: aan_1 (tables: paper, affiliation, author_list)
Question: Count the number of papers Columbia University had during or prior to 2009 .
SQL: select count(distinct 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 t1.year  <=  2009 and t3.name = "columbia university"
Database: aan_1 (tables: paper, author_list, affiliation)
Question: How many papers does Stanford University have between 2000 and 2009?
SQL: SELECT count(DISTINCT 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 T1.year  >=  2000 AND T1.year  <=  2009 AND T3.name LIKE "Stanford University"
Database: aan_1 (tables: paper, author_list, affiliation)
Question: Count the number of papers Stanford University had between 2000 and 2009.
SQL: SELECT count(DISTINCT 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 T1.year  >=  2000 AND T1.year  <=  2009 AND T3.name LIKE "Stanford University"
Database: aan_1 (tables: paper, author_list)
Question: What is the title of the paper that has most number of authors?
SQL: SELECT T2.title FROM Author_list AS T1 JOIN Paper AS T2 ON T1.paper_id  =  T2.paper_id GROUP BY T2.paper_id ORDER BY count(*) DESC LIMIT 1
Database: aan_1 (tables: paper, author_list)
Question: Give the title of the paper with the most authors.
SQL: SELECT T2.title FROM Author_list AS T1 JOIN Paper AS T2 ON T1.paper_id  =  T2.paper_id GROUP BY T2.paper_id ORDER BY count(*) DESC LIMIT 1
Database: aan_1 (tables: author, author_list)
Question: How many collaborators has Mckeown , Kathleen had ?
SQL: select count (distinct t2.author_id) from author_list as t1 join author_list as t2 on t1.paper_id  =  t2.paper_id and t1.author_id != t2.author_id join author as t3 on t1.author_id  =  t3.author_id where t3.name = "mckeown ,  kathleen"