Just adding replace function to remove '%' from the URL: select count(*) as cnt,regexp_replace(url,'%','') as urlt from tokenized_access_logs where url like '%\/product\/%' group by url order by cnt desc; ... View more