Please find all the papers published by "Aaron Turon"?
select t3.title from authors as t1 join authorship as t2 on t1.authid = t2.authid join papers as t3 on t2.paperid = t3.paperid where t1.fname = "Aaron" and t1.lname = "Turon"
Please find all the papers published by "Ralf Hinze"?
select t3.title from authors as t1 join authorship as t2 on t1.authid = t2.authid join papers as t3 on t2.paperid = t3.paperid where t1.fname = "Ralf" and t1.lname = "Hinze"
Can you add the paper IDs of those to the table please?
select t3.title,t3.paperid from authors as t1 join authorship as t2 on t1.authid = t2.authid join papers as t3 on t2.paperid = t3.paperid where t1.fname = "Ralf" and t1.lname = "Hinze"
Both please
select t1.lname,t1.fname from authors as t1 join authorship as t2 on t1.authid = t2.authid join papers as t3 on t2.paperid = t3.paperid group by t1.authid order by count ( * ) desc limit 1
What are the lname and fname of all authors that wrote exactly 1 paper?
select t1.lname,t1.fname from authors as t1 join authorship as t2 on t1.authid = t2.authid join papers as t3 on t2.paperid = t3.paperid group by t1.authid having count ( * ) = 1