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

Find the first and last name of the author(s) 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"
SELECT "t1"."fname", "t1"."lname" FROM "authors" "t1" JOIN "authorship" "t2" ON "t1"."authid" = "t2"."authid" JOIN "papers" "t3" ON "Nameless ,  Painless" = "t3"."title" AND "t2"."paperid" = "t3"."paperid"