Semantic Exception: 
Line 2:44 Expression not in GROUP BY key 'value'