SELECT Contentgroup, count(distinct Album, Contentgroup) as "pocet alb"...
Edit: teraz som si všimol group by ... ASC 
 Nepletieš si to s order by ?
SELECT Contentgroup, count(distinct Album, Contentgroup) as "pocet alb"...
Edit: teraz som si všimol group by ... ASC 
 Nepletieš si to s order by ?