What are the name of all the authors?
select fname, lname from authors
How many papers did each of them publish?
select t1.fname, t1.lname, count(*) from authors as t1 join authorship as t2 on t1.authid = t2.authid
Who published the most? Give me the last name.
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 group by t1.fname, t1.lname order by count(*) desc limit 1