how to determine the user distribution over different number of users?

Well, 9500 records between 1400 users, would mean that on average, each user would have about 25 or so records each.

If you break that down to say...four by the Beatles, a couple of Rolling Stones, one Beach Boys and say six made up from Elvis, Eddie Cochran and Roy Orbison, then the answer should be twelve.

Or James Brown, if you're working in musical terms.

I read this as saying they want a histogram with record count on the bin axis and number of users with that number of records on the count axis. How many users contributed one record? How many two records, etc. When you say you have 1400 users and 9500 records that sounds great as long as everyone has five to six records. If 1200 of them have only one record and the remaining two hundred contribute the other 8300 records, that tells a completely different story (and one that is not nearly as good.) That is my guess as to why they are asking.

@Lordyaswas, @engineer

Thanks a lot for your answers. Yeah, I think you're right. You solved a big problem that I was thinking about for a week

Regards