그룹내 시퀀스 생성

select id,CountryCode, 

      district,    

      (select count(*) from city c2 where c2.countrycode = c1.countrycode and c2.id <= c1.id) as seq    

from city c1;