select *,ROUND(CAST(CALC_PRICE as REAL) / CAST(total as REAL),2) as kousei FROM(
SELECT DTL.ITEM_CODE, SUM(DTL.UNITPRICE * DTL.DELIVERED_QTY) CALC_PRICE, (select sum(SALES_AMT) from SALES SLS 
where SALES_DATE BETWEEN '2023-06-01' AND '2023-06-30') as total FROM SALES_DTL DTL 
INNER JOIN SALES SLS 
ON DTL.SALES_NO = SLS.SALES_NO 
WHERE SLS.SALES_DATE BETWEEN '2023-06-01' AND '2023-06-30'
GROUP BY DTL.ITEM_CODE
ORDER BY CALC_PRICE DESC
) order by kousei desc
;