SELECT
   ITEM_CODE AS CODE
　,ITEM_NAME AS NAME
　,ORDERS_DTL_UNITPRICE * ORDERS_DTL_ORDER_QTY AS TOTAL_AMT
FROM
 ITEM
 INNER JOIN ORDERS_DTL
 ON ITEM_TYPE = ORDERS_DTL_ITEM_CODE
WHERE
 between ORDERS_ORDER_DATE 2023-05-14 and 2023-05-20
ORDER BY 
 TOTAL_AMT LIMIT 5;
 TOTAL_AMT
 ,ITEM_CODE desc;