-- SELECT DISTINCT
--     CUST_CODE AS CODE,
--     CUST_NAME AS NAME,
--     COUNT() AS CNT
-- FROM
--     CUSTOMER AS C
--     INNER JOIN ORDERS AS O ON C.CUST_CODE = O.CUST_CODE
-- WHERE
--     '2023-07-01' <= ORDER_DATE 
--     AND ORDER_DATE <= '2023-07-31'
-- GROUP BY
    
SELECT DISTINCT
    CODE,
    NAME,
    COUNT(CODE) AS CNT    
FROM
(
    SELECT DISTINCT
        C.CUST_CODE AS CODE,
        C.CUST_NAME AS NAME,
        ORDER_DATE
    FROM
        CUSTOMER AS C
        INNER JOIN ORDERS AS O ON C.CUST_CODE = O.CUST_CODE
    WHERE
        '2023-07-01' <= ORDER_DATE 
        AND ORDER_DATE <= '2023-07-31'
) AS temp_tbl
GROUP BY
    CODE
ORDER BY
    CNT DESC,
    CODE DESC