A
a
I have theis table
sereial room type Name JoinKey
1 DBL absfcii 1
2 DBL gfgfh 1
3 SNGL kkjjjk 2
4 SNGL sdjfksd 2
The Question Is
How can i count DBL in JoinKey 1 as (ONE) Only
How can I count SNGL in JoinKey 2 as (ONE) Only
sereial room type Name JoinKey
1 DBL absfcii 1
2 DBL gfgfh 1
3 SNGL kkjjjk 2
4 SNGL sdjfksd 2
The Question Is
How can i count DBL in JoinKey 1 as (ONE) Only
How can I count SNGL in JoinKey 2 as (ONE) Only