This is what I need to actually count.
( (Cte1.Roundtables = '1' OR Cte1.Roundtables= 'N/A')
(CTE1.IsVideo = '1' OR CTE1.IsVideo = 'N/A'))
SO, I am trying to count the # of Roundtables which have either a number or 'N/A' ( mentioned in the CTE)
and the count of IsVideo if its a number OR ;N/A.
and then do an AND on both their respective counts.