This one is driving me crazy. I want to exclude those who meet two conditions. They have been in my organization six months or less and have no cost. Its easy to query for them, but I can not think how to exclude them. To count them only it would be
WHERE t1.CostNM = 0 AND t1.Duration1 <= 6;
how do you say where not [cost =0 and duration <= 6]
WHERE t1.CostNM = 0 AND t1.Duration1 <= 6;
how do you say where not [cost =0 and duration <= 6]