NDepend CQL Count Query

Question

I want to query the table of public methods of a particular class and the number of methods used in NDepend CQL. Currently, the request is as follows:

SELECT METHODS 
FROM TYPES "AE.DataAccess.DBHelper" 
WHERE IsPublic

Is it possible to aggregate queries in CQL?

Answer 1

It looks like the following query will generate a beautiful table with the values ​​I was looking for that can be exported to Excel. What a wonderful tool.

CHOICE OF METHODS FROM TYPES "AE.DataAccess.DBHelper" WHERE IsPublic ORDER BY MethodCa DESC