select CUSTOMER.CUST_CODE as CODE, 
    CUSTOMER.CUST_NAME as NAME, 
    count(CUSTOMER.CUST_CODE) as CNT
from CUSTOMER
INNER JOIN ORDERS 
ON CODE = ORDERS.CUST_CODE
group by CODE;