select count(*) from theTable A inner join theTable B on (A.respondent = B.respondent) where (A.response_id = x and B.response_id = y);