CREATE TABLE authorship (authid VARCHAR2, paperid VARCHAR2)
CREATE TABLE papers (title VARCHAR2, paperid VARCHAR2)
CREATE TABLE authors (authid VARCHAR2, fname VARCHAR2, lname VARCHAR2)

Which papers have 'Stephanie Weirich' as an author?
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 = "Stephanie" AND t1.lname = "Weirich"
SELECT "t3"."title" FROM "authors" "t1" JOIN "authorship" "t2" ON "t1"."authid" = "t2"."authid" JOIN "papers" "t3" ON "t2"."paperid" = "t3"."paperid" WHERE "Stephanie" = "t1"."fname" AND "Weirich" = "t1"."lname"