i have a column called resident Type where i need to get sum of row which contains "-other" String but not "home -other " string .
i need to get sum as 4.
Now i am using below code but i get value 0. What i am doing wrong.
sum(if((wildmatch(resident Type,'*-other') and not wildmatch(resident Type,'home -other')),1,0)) = 0