fix(optimizer): correctly derive cardinality for group top-n (#18561)

fix(optimizer): correctly derive cardinality for group top-n (#18561) #6516