If your "empty" are indeed NULL then you can use:
select count(*) cAll, count(response) cnt1, count(response2) cnt2, count(response3) cnt3
from MyTableThe aggregate functions ignore null columns (except count(*) of course).
I am not one of those who in expressing opinions confine themselves to facts. (Mark Twain)