-- Database schema
| Inst : instID [ INT ] primary_key , name [ TEXT ] , country [ TEXT ] | Authors : authID [ INT ] primary_key , lname [ TEXT ] , fname [ TEXT ] | Papers : paperID [ INT ] primary_key , title [ TEXT ] | Authorship : authID [ INT ] primary_key Authorship.authID = Authors.authID , instID [ INT ] Authorship.instID = Inst.instID , paperID [ INT ] Authorship.paperID = Papers.paperID , authOrder [ INT ] |
-- -- Find the last names of all the authors that have written a paper with title containing the word "Monadic".

SELECT 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 LIKE "%Monadic%";