select 
CODE
,NAME
,SAL_AMT
,CML_AMT
,SAL_COMP,
TTL_COMP_num||'%' as TTL_COMP
,case 
when TTL_COMP_num <= 40.0 then 'A'
when TTL_COMP_num <= 80.0 then 'B'
else 'C'
end as RANK
from(
select 
CODE
,NAME
,SAL_AMT
,CML_AMT
,SAL_COMP,
ROUND(cast(CML_AMT as real)/(select sum(SALES_AMT) from SALES WHERE SALES_DATE BETWEEN '2023-06-01' AND '2023-06-30') *100,1) as TTL_COMP_num
from(
select CODE
,NAME
,SAL_AMT
,CML_AMT
, ROUND((cast(SAL_AMT as REAL)/MAX(CML_AMT) OVER () *100),1)||'%' as SAL_COMP
from(
select CODE
,NAME
,SAL_AMT
,SUM(SAL_AMT) OVER (ORDER BY SAL_AMT desc) AS CML_AMT
from(
select it.ITEM_CODE as CODE
,it.ITEM_NAME as NAME
,sum(UNITPRICE * SALES_QTY) as SAL_AMT
from SALES_DTL as dt
inner join ITEM as it
on dt.ITEM_CODE = it.ITEM_CODE
inner join SALES as sa
on sa.SALES_NO = dt.SALES_NO
where SALES_DATE <= '2023-06-30' and SALES_DATE >= '2023-06-01'
group by CODE
order by SAL_AMT desc,CODE desc)
)))