SELECT od.ITEM_CODE AS CODE, i.ITEM_NAME AS NAME, (od.UNITPRICE * od.ORDER_QTY) AS TOTAL_AMT
FROM ORDERS_DTL od JOIN ORDERS o ON od.ORDER_NO == o.ORDER_NO JOIN ITEM i ON od.ITEM_CODE == i.ITEM_CODE
WHERE o.ORDER_DATE >= "2023-05-20" AND o.ORDER_DATE <= "2023-05-14"
ORDER BY 3, 1;