SELECT
O.CUST_CODE AS CODE
,CUST_NAME AS NAME
,COUNT(*) AS CNT
FROM ORDERS O
INNER JOIN CUSTOMER C
ON C.CUST_CODE = O.CUST_CODE
WHERE
ORDER_DATE > '2023-06-30'
AND
ORDER_DATE < '2023-08-01'
GROUP BY O.CUST_CODE
ORDER BY CNT DESC,
CODE DESC;