human
Schema:
venue (venueId, venueName)
author (authorId, authorName)
dataset (datasetId, datasetName)
journal (journalId, journalName)
keyphrase (keyphraseId, keyphraseName)
paper (paperId, title, venueId, year, numCiting, numCitedBy, journalId)
cite (citingPaperId, citedPaperId)
paperDataset (paperId, datasetId)
paperKeyphrase (paperId, keyphraseId)
writes (paperId, authorId)
Please answer with SQL.
assistant
Sure, I understand.
human
What articles have been published since 2006 about the effects of juicing for cancer patients ?
assistant
SELECT DISTINCT paperid , title FROM paper WHERE title LIKE 'the effects of juicing for cancer patients' AND YEAR > 2006;
human
How many authors published at sigcse in 2010 ?
assistant
SELECT DISTINCT COUNT ( t2.paperid ) FROM venue AS t3 JOIN paper AS t2 ON t3.venueid = t2.venueid JOIN writes AS t1 ON t1.paperid = t2.paperid WHERE t2.year = 2010 AND t3.venuename = 'sigcse';
human
what papers were published in Academic radiology in 1995 ?
assistant
SELECT DISTINCT t2.paperid FROM paper AS t2 JOIN journal AS t1 ON t2.journalid = t1.journalid WHERE t1.journalname = 'Academic radiology' AND t2.year = 1995;
human
How many publications were added to the Cell journal this year ?
assistant
SELECT DISTINCT COUNT ( t3.paperid ) FROM paper AS t3 JOIN journal AS t2 ON t3.journalid = t2.journalid JOIN paperkeyphrase AS t1 ON t3.paperid = t1.paperid WHERE t2.journalname = 'Cell' AND t3.year = 2015;
human
Which authors published papers in 2015 ?
assistant
SELECT DISTINCT t1.authorid FROM writes AS t1 JOIN paper AS t2 ON t1.paperid = t2.paperid WHERE t2.year = 2015;
human
Who are the prominent researchers in Neutralizing Antibody in 2012 ?
assistant
SELECT DISTINCT COUNT( t4.paperid ) , t3.authorid FROM paperkeyphrase AS t1 JOIN keyphrase AS t2 ON t1.keyphraseid = t2.keyphraseid JOIN paper AS t4 ON t4.paperid = t1.paperid JOIN writes AS t3 ON t3.paperid = t4.paperid WHERE t2.keyphrasename = "Neutralizing Antibody" AND t4.year = 2012 GROUP BY t3.authorid ORDER BY COUNT( t4.paperid ) DESC ;