What are all the papers?
select * from papers
What are the name of all the authors?
select fname, lname from authors
Which papers did "Olin Shivers" write?
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 = "Olin" and t1.lname = "Shivers"