1、
SELECT T.OPN_BRANCH ,
COUNT(DISTINCT T.CUST_NBR||T.NBR_TYPE) AS NUM
FROM
(select T3.OPN_BRANCH ,
T3.CUST_NBR ,
T3.NBR_TYPE
FROM
ODM.T_ACCT T1 ,
ODM.T_ACCT_CUST T2 ,
ODM.T_CUST_INFO T3,
ODM.T_ACCT_INFO T5
WHERE
T1.ACCT_ID = T2.ACCT_ID
AND
T2.CUST_ID = T3.CUST_ID
AND
T3.OPN_DATE = (SELECT MIN(T4.OPN_DATE) FROM ODM.T_CUST_INFO T4