What are all the papers?
select * from papers
What are the name of all the authors?
select fname, lname from authors
Who wrote the paper "Nameless, Painless"?
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 = "Nameless, Painless"