WITH NAMES AS (
    SELECT
        ITEM_CODE AS CODE,
        ITEM_NAME AS NAME
    FROM
        ITEM
),
ORDERS_DTLS AS (
    SELECT
        ITEM_CODE,
        SUM(UNITPRICE * ORDER_QTY) AS PRICE
    FROM
        ORDERS_DTL
    WHERE ORDER_NO in
    (SELECT ORDER_NO
    FROM ORDERS
    WHERE ORDER_DATE BETWEEN DATE('2023-05-14') AND DATE('2023-05-20'))
    group by ITEM_CODE
)
select
NAMES.CODE,
NAMES.NAME,
ORDERS_DTLS.PRICE
FROM NAMES left outer join ORDERS_DTLS on NAMES.CODE = ORDERS_DTLS.ITEM_CODE
order by PRICE desc,
CODE desc