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