Have:
ID | flag |
---|---|
1 | r |
1 | a |
2 | |
2 | |
3 | a |
3 | |
4 | r |
4 | |
5 | r |
5 | |
6 | r |
6 | a |
Want:
Combination | Count |
---|---|
a-r | 2 |
r | 2 |
a | 1 |
None | 1 |
Have:
ID | flag |
---|---|
1 | r |
1 | a |
2 | |
2 | |
3 | a |
3 | |
4 | r |
4 | |
5 | r |
5 | |
6 | r |
6 | a |
Want:
Combination | Count |
---|---|
a-r | 2 |
r | 2 |
a | 1 |
None | 1 |