removed unnecessary and syntax-violating group by statement.