Removed select star and group by

Removed select* and group by and instead added the column names and select distinct
According to discussion on slack @nadeeshaan  please roll back ordering. 
Thanks.