SELECT
        I.ITEM_CODE AS CODE
       ,I.ITEM_NAME AS NAME
       ,SUM((D.UNITPRICE * D.ORDER_QTY)) AS TOTAL_AMT
    FROM
        ORDERS     O
       ,ORDERS_DTL D
       ,ITEM       I
    WHERE
        -- ORDERSの絞り込み
        O.ORDER_DATE BETWEEN '2023-05-14' AND '2023-05-20'
        -- ORDERSとORDERS_DTLの結合
    AND O.ORDER_NO = D.ORDER_NO
        -- ORDERS_DTLとITEMの結合
    AND D.ITEM_CODE = I.ITEM_CODE
    
    GROUP BY
        CODE
       ,NAME
    ORDER BY
        TOTAL_AMT DESC
       ,CODE      DESC
    
    LIMIT 5
;