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
List today 's journals
assistant
SELECT DISTINCT journalid FROM paper WHERE YEAR = 2011 GROUP BY journalid;
human
What journals are Takashi Matsumoto 's articles published in ?
assistant
SELECT DISTINCT t3.journalid FROM writes AS t2 JOIN author AS t1 ON t2.authorid = t1.authorid JOIN paper AS t3 ON t2.paperid = t3.paperid WHERE t1.authorname = 'Takashi Matsumoto' GROUP BY t3.journalid;
human
papers citing Daniel Jurafsky
assistant
SELECT DISTINCT t3.paperid FROM paper AS t3 JOIN cite AS t4 ON t3.paperid = t4.citingpaperid JOIN writes AS t2 ON t2.paperid = t4.citedpaperid JOIN author AS t1 ON t2.authorid = t1.authorid WHERE t1.authorname = 'Daniel Jurafsky';
human
in what journals does linda shapiro publish ?
assistant
SELECT DISTINCT t2.journalid FROM paper AS t3 JOIN journal AS t2 ON t3.journalid = t2.journalid JOIN writes AS t4 ON t4.paperid = t3.paperid JOIN author AS t1 ON t4.authorid = t1.authorid WHERE t1.authorname = 'linda shapiro';
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
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 ;