CALENDAR    CLIENTID
20180801    178
20180802    178
20180803    578

select clientid,
 ROW_NUMBER() OVER ( partition by clientid ORDER BY max(calendar) desc )
 from STATS
 group by clientid

select clientid, count(*)
from stats
group by clientid;