with ZHUSU as(
SELECT * FROM t_ga_zhusu
)
SELECT DISTINCT FIRST_VALUE(ID) OVER(PARTITION BY T1.CERTNO ORDER BY T1.CHECINTIME DESC NULLS LAST, T1.ID DESC) ID,
(select count(1) from ZHUSU T4 where T4.CERTNO = T1.CERTNO) num
FROM ZHUSU T1;