with tmp as(
Select a.*,b.TOTAL_VALUE as mise from
CONVENIENCE a inner join CONVENIENCE b
on a.PF_CODE=b.PF_CODE
where
a.KIND_CODE=100
and b.KIND_CODE=150
and a.SURVEY_YEAR=2019
and b.SURVEY_YEAR=2019
), tmp2 as(

SELECT
*,ntile(10) over(partition by kind_code order by TOTAL_VALUE desc,mise asc,PF_CODE asc) rr
FROM 
tmp
WHERE SURVEY_YEAR =2019
and KIND_CODE = '100'

),
tmp3 as(
select sum(total_value) ss,
sum(mise) over(partition by rr) mm
,
rr

from tmp2
group by rr
),
tt as (select sum(total_value) t from tmp2),
mm as (select sum(mise) mise,rr from tmp2 group by rr)
SELECT
ss TTL_SAL,
ROUND(sum(ss) over (order by tmp3.rr )*100.0/t ,1) CUM_SAL ,
ROUND(ss/mise,1) AVG_SAL,
ROUND(ss*100.0/t,1) PER_SAL,

tmp3.rr NO
from tt,tmp3 left join mm on tmp3.rr=mm.rr