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

Find the first names of all the authors who have written a paper with title containing the word 'Functional'.
SELECT t1.fname 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 LIKE "%Functional%"
SELECT "t1"."fname" FROM "authors" "t1" JOIN "authorship" "t2" ON "t1"."authid" = "t2"."authid" JOIN "papers" "t3" ON "t2"."paperid" = "t3"."paperid" AND "t3"."title" LIKE "%Functional%"