Semantic Exception: 
Line 2:85 SELECT DISTINCT and GROUP BY can not be in the same query key