In excel there is a simple formula to calculate the number of items in an array. See the attached image. How can a column Q be calculated using SQL?
I think we will need more than just a screen shot of Excel. What is the relationship between the highlighted columns.
SELECT Sum(CASE WHEN [condition check] THEN 1 ELSE 0 END) FROM SourceObject;