-- 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 ] |
-- -- Which authors have first name "Amal"? List their last names.

SELECT lname FROM authors WHERE fname  =  "Amal";