removed group by clause instead added select distinct

removed group by clause instead added select distinct