with uriage as (
select
    SALES_DTL.ITEM_CODE
    ,ITEM_NAME
    ,sum(UNITPRICE  * SALES_QTY) as SAL_AMT
from SALES
inner join SALES_DTL
    on SALES.SALES_NO  = SALES_DTL.SALES_NO
inner join ITEM
    on SALES_DTL.ITEM_CODE = ITEM.ITEM_CODE
where SALES_DATE >= '2023-06-01' and SALES_DATE <='2023-06-30'
group by 
    SALES_DTL.ITEM_CODE
    ,ITEM_NAME
order by 
    SAL_AMT desc
    ,SALES_DTL.ITEM_CODE desc
), goukei as (
select
    sum(UNITPRICE  * SALES_QTY) as goukei
from SALES
inner join SALES_DTL
    on SALES.SALES_NO  = SALES_DTL.SALES_NO
where SALES_DATE >= '2023-06-01' and SALES_DATE <='2023-06-30'
)
select * 
    ,round(cast(SAL_AMT as real) /cast( (select goukei from goukei) as real)  * 100 ,1) || '%' as SAL_COMP
from uriage