removed unnecessary group by method