SELECT 


ITEM.ITEM_CODE AS CODE
,ITEM.ITEM_NAME AS NAME
,SUM(ORDERS_DTL.UNITPRICE * ORDERS_DTL.ORDER_QTY) AS TOTAL_AMT


FROM ITEM

LEFT OUTER JOIN ORDERS_DTL
ON ITEM.ITEM_CODE = ORDERS_DTL.ITEM_CODE

LEFT OUTER JOIN ORDERS
ON ORDERS_DTL.ORDER_NO = ORDERS.ORDER_NO

WHERE ORDER_DATE BETWEEN '2023-05-14' AND '2023-05-20'

GROUP BY ITEM.ITEM_CODE,ITEM.ITEM_NAME
ORDER BY SUM(ORDERS_DTL.UNITPRICE * ORDERS_DTL.ORDER_QTY) DESC,ITEM.ITEM_CODE DESC
LIMIT 5