SQL programs

Data

Name Find the 200 most prolific ModelDB paper authors

Description

SQL Program select author.object_id,author.object_name, count(paper_author.object_id) from objects author, eav_objects paper_author where author.object_class=44 and paper_author.attribute_id=148 and author.object_id = paper_author.value_ group by author.object_id,author.object_name order by COUNT(paper_author.OBJECT_ID) DESC, author.object_name

Maximum Rows 200

Maximum Columns