select count(answer1) as total, questionsResults.answer1
from questionsResults
WHERE correct=1 GROUP by answer1
select count(answer1) as total, questionsResultselect count(answer1) as total, questionsResults.answer1
from questionsResults
WHERE correct=1 GROUP by answer1
select count(answer1) as total, questionsResult