Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.
/* count of yes/no (and unanswered) for question 1: */
SELECT q1,count(*) FROM MyTable
/* Sum of yes/no replies to questions q1-q4: */
SELECT
sum(if(q1='yes',1,0)) as q1_yes,
sum(if(q1='no',1,0)) as q1_no,
sum(if(q2='yes',1,0)) as q2_yes,
sum(if(q2='no',1,0)) as q2_no,
sum(if(q3='yes',1,0)) as q3_yes,
sum(if(q3='no',1,0)) as q3_no,
sum(if(q4='yes',1,0)) as q4_yes,
sum(if(q4='no',1,0)) as q4_no
FROM MyTable
SELECT
sum(if(q1='yes',1,0)) as q1_yes,
sum(if(q1='no',1,0)) as q1_no,
sum(if(q2='yes',1,0)) as q2_yes,
sum(if(q2='no',1,0)) as q2_no,
sum(if(q3='yes',1,0)) as q3_yes,
sum(if(q3='no',1,0)) as q3_no,
sum(if(q4='yes',1,0)) as q4_yes,
sum(if(q4='no',1,0)) as q4_no
/* repeat this for each question */
FROM results
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join the community of 500,000 technology professionals and ask your questions.