多列中的TSQL计数出现次数

I have a table where each column is a question and rows are answers that can assume value from 1 to 4I have a table where each column is a question