select left(ks835030, 3), count(*) from a540769.twk925a1 where part = 2 group by left(ks835030, 3) order by 1 with ur