id brand rank=(count*)
1  A     1
2  B     1
3  A     2
4  A     3
5  B     2
...