SELECT S.CODE, I.ITEM_NAME AS NAME, S.TOTAL_AMT
FROM (
    SELECT ITEM_CODE CODE, SUM(ORDER_QTY)*UNITPRICE AS TOTAL_AMT
    FROM ORDERS_DTL
    WHERE ORDER_NO IN
    (
        SELECT ORDER_NO
        FROM ORDERS
        WHERE ORDER_DATE BETWEEN "2023-05-14" AND "2023-05-20"
    )
    GROUP BY ITEM_CODE
    ORDER BY TOTAL_AMT DESC, ITEM_CODE DESC
    LIMIT 5
) AS S
JOIN ITEM AS I
ON S.CODE = I.ITEM_CODE