Who has written a paper that has the word "Functional" in its title? Return the first names of the authors.
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%"
paper with 'Functional' in its title refers to title LIKE '%Functional%'; first names of the authors refers to fname; written a paper implies joining authors, authorship, and papers tables.