统计每种车型的数量
SELECT T1.CARMODELPKID,COUNT(1) FROM RT_CUSTALLOCRESULT T LEFT JOIN VM_CARINFO T1 ON T1.FRAMENO = T.FRAMENO LEFT JOIN RT_CUSTFOLLOWUP T2 ON T2.REGNO = T.REGNO WHERE T1.CARMODELPKID IS NOT NULL AND T2.DEFEATREASON IS NOT NULL GROUP BY CARMODELPKID