how to count separate column in this Query.

hi
my Query output like this see the image attachment

id Q1 Q2 Q3 Q4 Q5
============================
1 65 1 2 0 2
2 1 2 2 0 1
3 2 1 1 1 2
4 1 1 2 0 1
5 2 2 0 0 2
6 2 0 1 1 1

i need here how much 1 and how much 2 and other value in Q1 and Q2 etc but
i need each column 3 output how much 1 and howmuch 2 and how much other value how to count and show other column .

Mark as Answer if its helpful to you

Regards
Email Id: kumaraspcode2009@gmail.com