WITH f AS(
    SELECT
        *
    FROM
        ORDERS
    WHERE
        ORDER_DATE > '2023-05-13'
        AND ORDER_DATE < '2023-05-21'
),
p AS(
    SELECT
        od.ITEM_CODE ic,
        od.UNITPRICE * od.ORDER_QTY AS price
    FROM
        f
        INNER JOIN ORDERS_DTL od ON f.ORDER_NO = od.ORDER_NO
)
SELECT
    p.ic CODE,
    i.ITEM_NAME NAME,
    sum(p.price) TOTAL_AMT
FROM
    p
    INNER JOIN ITEM i ON i.ITEM_CODE = p.ic
GROUP BY
    p.ic
ORDER BY
    TOTAL_AMT DESC
LIMIT
    5