SELECT
CUSTOMER.CUST_CODE as CODE,
CUSTOMER.CUST_NAME as NAME,
count(ORDERS.CUST_CODE) as CNT
FROM
ORDERS INNER JOIN CUSTOMER ON CUSTOMER.CUST_CODE = ORDERS.CUST_CODE
WHERE
ORDERS.ORDER_DATE BETWEEN '2023-07-01' AND '2023-07-31'


GROUP BY ORDERS.CUST_CODE

ORDER BY CNT DESC,
         CODE DESC;