Unnamed

select A.answer, COUNT(V.answer_id) as votes from poll_answers A, poll_votes V where A.poll_id = V.poll_id  and A.poll_id = 4 group by V.answer_id