VOTE

Name	Vote1	Vote2
Bill	20	15
Mary	10	25
Jill	15	0
Bob	30	null

SELECT COUNT(*) AS Nrows, COUNT(VOTE2) AS NVOTE2 FROM VOTE The execution of this query produces the following result (Nrows shown before NVOTE2):

4, 4

3, 3

4, 3

4, null