Count Multiple Columns - Newbie

[dbasnett]

This seems to work:

SELECT ctid, count( * ) AS cts
FROM (
SELECT c1 AS ctid
FROM ads
WHERE c1 IS NOT NULL
UNION ALL
SELECT c2 AS ctid
FROM ads
WHERE c2 IS NOT NULL
) AS baseview
GROUP BY ctid