SELECT
 TBL2.ITEM_CODE AS CODE
 , TBL3.ITEM_NAME AS NAME
 , SUM(TBL2.UNITPRICE * TBL2.ORDER_QTY) AS TOTAL_AMT
FROM
 ORDERS TBL1
INNER JOIN
 ORDERS_DTL TBL2
ON
 TBL1.ORDER_NO = TBL2.ORDER_NO
INNER JOIN
 ITEM TBL3
ON
 TBL2.ITEM_CODE = TBL3.ITEM_CODE
WHERE
 TBL1.ORDER_DATE > '2023-05-13' AND TBL1.ORDER_DATE < '2023-05-21'
GROUP BY
 TBL2.ITEM_CODE
 , TBL3.ITEM_NAME
ORDER BY
 SUM(TBL2.UNITPRICE * TBL2.ORDER_QTY) DESC,
 TBL2.ITEM_CODE ASC
 LIMIT 5
;