I have database like given below

A B C D E
Q2 a c c a
Q2 b a a a
Q1 d a a
Q2 c a
Q1 d a b a

I want to count how many "a" are there in different column for Q1, or how
many "c" are there in different column for Q2. (Q1 & Q2 are only in A column.)