select rtrim(a.eparchy_code),rtrim(a.CITY_CODE),rtrim(b.CITY_name),
row_number() over(partition by rtrim(a.eparchy_code) order by sum(kpi_value01) desc),
row_number() over(partition by rtrim(a.eparchy_code) order by sum(kpi_value02) desc),
sum(kpi_value02),sum(kpi_value03),sum(kpi_value04),
sum(kpi_value05),sum(kpi_value06),sum(kpi_value07),sum(kpi_value08),
sum(kpi_value09),sum(kpi_value10)
from TF_f_MAP_city_MON a,TYMX.TD_I_CITYCODE b
where a.CITY_CODE=b.CITY_CODE and time_m=186
and a.CITY_CODE not like '%Z%' group by rtrim(a.CITY_CODE),a.time_m,rtrim(b.CITY_name),rtrim(a.eparchy_code)