SELECT distinct
    CUST_CODE AS CODE
    ,CUST_NAME AS NAME
    ,COUNT(CUST_CODE) AS CNT
FROM (
SELECT distinct 
    CUST_CODE
    ,CUST_NAME
    ,ORDER_DATE
FROM (
SELECT * FROM CUSTOMER
LEFT JOIN ORDERS
ON CUSTOMER.CUST_CODE = ORDERS.CUST_CODE
)
)
WHERE ORDER_DATE >= '2023-07-01' AND ORDER_DATE <= '2023-07-31'
GROUP BY CUST_CODE,CUST_NAME
ORDER BY COUNT(CUST_CODE) DESC,CUST_CODE DESC