SELECT
ORD_DTL.ITEM_CODE AS CODE
,MAX(ITEM.ITEM_NAME) AS NAME
,SUM(ORD_DTL.UNITPRICE * ORD_DTL.ORDER_QTY) AS TOTAL_AMT
FROM ORDERS AS ORD
     INNER JOIN ORDERS_DTL AS ORD_DTL
         ON ORD.ORDER_NO  = ORD_DTL.ORDER_NO 
     INNER JOIN ITEM
         ON ORD_DTL.ITEM_CODE = ITEM.ITEM_CODE
WHERE ORD.ORDER_DATE BETWEEN '2023-05-14'
                         AND '2023-05-20'
GROUP BY ORD_DTL.ITEM_CODE
ORDER BY TOTAL_AMT DESC, ORD_DTL.ITEM_CODE DESC
LIMIT 5
;