-- Database schema
| Inst : instID [ INT ] primary_key , name [ TEXT ] , country [ TEXT ] | Authors : authID [ INT ] primary_key , lname [ TEXT ] , fname [ TEXT ] | Papers : paperID [ INT ] primary_key , title [ TEXT ] | Authorship : authID [ INT ] primary_key Authorship.authID = Authors.authID , instID [ INT ] Authorship.instID = Inst.instID , paperID [ INT ] Authorship.paperID = Papers.paperID , authOrder [ INT ] |
-- -- Which papers did the author "Olin Shivers" write? Give me the paper titles.

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";