i've prepared a case, but I want to filter the A part.I don't want the "others" ones to come.
"Case when......
when GROUP(OX)='T0' AND DAYS>30 THEN 'ANSWERS' ELSE 'OTHERS' END A"
i mean, how do I filter with having?
HAVING NOT IN GROUP='OTHERS';
İts not working :(