SELECT
    ORDERS.CUST_CODE AS CODE
    , CUST_NAME AS NAME
    , COUNT(distinct concat(date_format(日時,'%Y%m%d') AND ORDERS.CUST_CODE OR NULL) AS CNT
FROM
    ORDERS
    , CUSTOMER
WHERE
    ORDER_DATE
ORDER BY 
    CNT DESC
    ,  CODE DESC;