Unnamed
public sql v1 · immutableSELECT A.answer, COUNT(V.answer_id) AS votesFROM poll_answers A LEFT 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_idGROUP BY A.answerSELECT A.answer, COUNT(V.answer_id) AS votesFROM poll_answers A LEFT 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_idGROUP BY A.answer