Hello!  Can you provide me with a list of all paper IDs and paper titles that correspond to "Indiana University"?
select distinct t1.title,t1.paperid from papers as t1 join authorship as t2 on t1.paperid = t2.paperid join inst as t3 on t2.instid = t3.instid where t3.name = "Indiana University"
Great!  Can you please list all of the author Ids that are associated with that paper title?
select distinct t2.authid from papers as t1 join authorship as t2 on t1.paperid = t2.paperid join inst as t3 on t2.instid = t3.instid where t1.title = ( select distinct t1.title from papers as t1 join authorship as t2 on t1.paperid = t2.paperid join inst as t3 on t2.instid = t3.instid where t3.name = "Indiana University" )
Great! Can you tell me what the total number of papers are for each of these author IDs?...in other words, how many papers have each of these authors published?
select authid,count ( * ) from authorship group by authid