WITH t1 AS (SELECT ITEM_CODE, SUM(UNITPRICE * SALES_QTY) AS amt
            FROM sales
                 INNER JOIN SALES_DTL de ON de.sales_no = sales.SALES_NO
            WHERE SALES_DATE BETWEEN '2023-06-01' AND '2023-06-30'
            GROUP BY ITEM_CODE)
   , t2 AS (SELECT t1.ITEM_CODE
                 , SUM(t2.amt) v0
                 , CAST(MAX(t1.amt) AS real) / (SELECT SUM(amt) FROM t1) v1
                 , CAST(IFNULL(SUM(t2.amt), 0) AS real) / (SELECT SUM(amt) FROM t1) v2
            FROM t1
                 LEFT JOIN t1 t2 ON t2.amt >= t1.amt
            GROUP BY t1.ITEM_CODE)
SELECT t1.ITEM_CODE CODE
     , ITEM_NAME NAME
     , t1.amt SAL_AMT
     , t2.v0 CML_AMT
     , ROUND(t2.v1 * 100, 1) || '%' SAL_COMP
     , ROUND(t2.v2 * 100, 1) || '%' TTL_COMP
     , CASE
           WHEN ROUND(t2.v2 * 100, 1) <= 40 THEN 'A'
           WHEN ROUND(t2.v2 * 100, 1) <= 80 THEN 'B'
           ELSE 'C' END AS RANK
FROM t1
     JOIN t2 ON t1.ITEM_CODE = t2.ITEM_CODE
     JOIN ITEM ON ITEM.ITEM_CODE = t2.ITEM_CODE

ORDER BY 3 DESC, 1 DESC