move gps column out of group by clause