Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys
I have a table like :
Id Type
1 A
1 B
1 C
2 A
2 B
3 A
4 B
and i need the output in a straight table like
Type Count(Id)
A 3
B 3
A + B 2
A+B+C 1