Semantic Exception: 
2:88 SELECT DISTINCT and GROUP BY can not be in the same query. Error encountered near token 'key'