Something
public sql v1 · immutableselect A.answer, COUNT(V.answer_id) as votes from poll_answers ALEFT JOIN poll_votes V ON A.poll_id = V.poll_id AND A.id = V.answer_idwhere A.poll_id = 4 and A.id = V.answer_id group by A.answerselect A.answer, COUNT(V.answer_id) as votes from poll_answers ALEFT JOIN poll_votes V ON A.poll_id = V.poll_id AND A.id = V.answer_idwhere A.poll_id = 4 and A.id = V.answer_id group by A.answer