当其他字段不重复时，选择字段的最小分数

I have some columns and one is username and its value is duplicated and credit field have some value I have to find count(username) without duplication while its credit field is between two value. I have some columns and one is username and its