SELECT
    IT.ITEM_CODE AS CODE
  , IT.ITEM_NAME AS NAME
  , ORDD.UNITPRICE * SUM(ORDD.ORDER_QTY) AS TOTAL_AMT
FROM
    ITEM IT
    LEFT OUTER JOIN ORDERS_DTL ORDD
    ON IT.ITEM_CODE = ORDD.ITEM_CODE
    INNER JOIN ORDERS ORD
    ON ORDD.ORDER_NO = ORD.ORDER_NO
WHERE
    ORD.ORDER_DATE IN
    ('2023-05-14','2023-05-15','2023-05-16','2023-05-17','2023-05-18','2023-05-19','2023-05-20')
GROUP BY CODE
ORDER BY TOTAL_AMT DESC LIMIT 5