What is the title of the paper that has the largest number of authors?
select t2.title from authorship as t1 join papers as t2 on t1.paperid = t2.paperid where t1.authorder = ( select max ( authorder ) from authorship )
How many authors are there?
select count ( distinct authid ) from authorship
What is the title of the paper that has the smallest number of authors?
select t2.title from authorship as t1 join papers as t2 on t1.paperid = t2.paperid where t1.authorder = ( select min ( authorder ) from authorship )
What is the average number of authors for all titles?
select paperid,avg ( authorder ) from authorship group by paperid