GROUP BY in search results?

[Cdalitz]

Is it possible to do something similar to the "GROUP BY" in SQL (or "table()" in R) when searching CPDL?

In particular, I am trying to list and count the languages used for specific texts, e.g.

Code: Select all

SELECT language, COUNT(*) FROM all_pieces WHERE "LinkText" = 'Magnificat' GROUP BY language ORDER BY COUNT(*) DESC