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 number of references of ' Making database systems usable ' .
assistant
SELECT reference_num FROM publication WHERE title = 'Making database systems usable';
human
return me the conference, which published ' Making database systems usable ' .
assistant
SELECT t1.name FROM publication AS t2 JOIN conference AS t1 ON t2.cid = t1.cid WHERE t2.title = 'Making database systems usable';
human
return me the abstract of ' Making database systems usable ' .
assistant
SELECT abstract FROM publication WHERE title = 'Making database systems usable';
human
return me the keywords of ' Making database systems usable ' .
assistant
SELECT t1.keyword FROM publication_keyword AS t3 JOIN keyword AS t1 ON t3.kid = t1.kid JOIN publication AS t2 ON t2.pid = t3.pid WHERE t2.title = 'Making database systems usable';
human
return me the number of authors of ' Making database systems usable ' .
assistant
SELECT COUNT ( DISTINCT t1.name ) FROM writes AS t2 JOIN author AS t1 ON t2.aid = t1.aid JOIN publication AS t3 ON t2.pid = t3.pid WHERE t3.title = 'Making database systems usable';
human
return me the authors of ' Making database systems usable ' .
assistant
SELECT t1.name FROM writes AS t2 JOIN author AS t1 ON t2.aid = t1.aid JOIN publication AS t3 ON t2.pid = t3.pid WHERE t3.title = "Making database systems usable" ;