What are the titles of papers published by "Jeremy Gibbons"?
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  =  "Jeremy" AND t1.lname  =  "Gibbons"
titles of papers published by a given author involves JOIN operation between authors, authorship, and papers tables; filtering by author's name requires WHERE clause with conditions on first name (fname) and last name (lname);