SQL programs

Data

Name Find the 100 Most Cited Papers

Description Finds the top 100 Cited ModelDB papers.

SQL Program select paper.object_id,paper.object_name, count(citations.object_id) from objects paper, eav_objects citations where paper.object_class=42 and citations.attribute_id=140 and paper.object_id = citations.value_ group by paper.object_id,paper.object_name order by COUNT(CITATIONS.OBJECT_ID) DESC, paper.object_name

Maximum Rows 100

Maximum Columns