Count over partition by. Count distinct. count * from where.