What are the name of all the authors?
select fname, lname from authors
Who published the paper "Binders Unbound"?
select t1.fname, t1.lname from authors as t1 join authorship as t2 on t1.authid = t2.authid join papers as t3 on t2.paperid = t3.paperid where t3.title = "Binders Unbound"
Give me only the last names.
select t1.fname, t1.lname from authors as t1 join authorship as t2 on t1.authid = t2.authid join papers as t3 on t2.paperid = t3.paperid where t3.title = "Binders Unbound"