Add support of the GROUP N BY, WITHIN GROUP ORDER BY

[Koc]

It would be useful provide sorting before groupping using WITHIN GROUP ORDER BY and find top N results per group using GROUP N BY. For example we should display last 10 photos per album

SELECT FROM Photo p GROUP 10  BY p.album WITHIN GROUP ORDER BY p.createdAt DESC