SQL计数和不同和分区

I am trying out some examples with analytical functions and i have created a sql fiddle to understand a count distinct over partition by clause.This is my I am trying out some examples with analytical f