human
Schema:
author (aid, homepage, name, oid)
conference (cid, homepage, name)
domain (did, name)
domain_author (aid, did)
domain_conference (cid, did)
journal (homepage, jid, name)
domain_journal (did, jid)
keyword (keyword, kid)
domain_keyword (did, kid)
publication (abstract, cid, citation_num, jid, pid, reference_num, title, year)
domain_publication (did, pid)
organization (continent, homepage, name, oid)
publication_keyword (pid, kid)
writes (aid, pid)
cite (cited, citing)
Please answer with SQL.
assistant
Sure, I understand.
human
return me the paper after 2000 in Databases area with more than 200 citations .
assistant
SELECT t3.title FROM DOMAIN AS t2 JOIN domain_publication AS t1 ON t2.did = t1.did JOIN publication AS t3 ON t3.pid = t1.pid WHERE t2.name = 'Databases' AND t3.citation_num > 200 AND t3.year > 2000;
human
return me the author in the ' University of Michigan ' whose papers in Databases area have the most total citations .
assistant
SELECT t1.name FROM DOMAIN AS t4 JOIN domain_publication AS t2 ON t4.did = t2.did JOIN publication AS t5 ON t5.pid = t2.pid JOIN writes AS t3 ON t3.pid = t5.pid JOIN author AS t1 ON t3.aid = t1.aid JOIN organization AS t6 ON t6.oid = t1.oid WHERE t4.name = 'Databases' AND t6.name = 'University of Michigan' GROUP BY t1.name ORDER BY SUM ( t5.citation_num ) DESC LIMIT 1;
human
return me the paper with the most citations .
assistant
SELECT title FROM publication ORDER BY citation_num DESC LIMIT 1;
human
return me the paper after 2000 in Databases area with the most citations .
assistant
SELECT t3.title FROM DOMAIN AS t2 JOIN domain_publication AS t1 ON t2.did = t1.did JOIN publication AS t3 ON t3.pid = t1.pid WHERE t2.name = 'Databases' AND t3.year > 2000 ORDER BY t3.citation_num DESC LIMIT 1;
human
return me the paper in Databases area with more than 200 citations .
assistant
SELECT t3.title FROM DOMAIN AS t2 JOIN domain_publication AS t1 ON t2.did = t1.did JOIN publication AS t3 ON t3.pid = t1.pid WHERE t2.name = 'Databases' AND t3.citation_num > 200;
human
return me the paper in Databases area with the most citations .
assistant
SELECT t3.title FROM DOMAIN AS t2 JOIN domain_publication AS t1 ON t2.did = t1.did JOIN publication AS t3 ON t3.pid = t1.pid WHERE t2.name = "Databases" ORDER BY t3.citation_num DESC LIMIT 1 ;