CREATE TABLE papers (paperid DECIMAL, title TEXT)
CREATE TABLE authorship (authid DECIMAL, instid DECIMAL, paperid DECIMAL, authorder DECIMAL)
CREATE TABLE inst (instid DECIMAL, name TEXT, country TEXT)
CREATE TABLE authors (authid DECIMAL, lname TEXT, fname TEXT)

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"
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 "Olin" = "t1"."fname" AND "Shivers" = "t1"."lname"