removed the unnecessary group by look up