Stuff
public sql v1 · immutableSELECT A.answer, COUNT( V.answer_id ) AS votes, ******* AS total_votesFROM poll_answers ALEFT JOIN poll_votes V ON A.poll_id = V.poll_idAND A.id = V.answer_idWHERE A.poll_id = 42AND A.id = V.answer_idGROUP BY A.answerSELECT A.answer, COUNT( V.answer_id ) AS votes, ******* AS total_votesFROM poll_answers ALEFT JOIN poll_votes V ON A.poll_id = V.poll_idAND A.id = V.answer_idWHERE A.poll_id = 42AND A.id = V.answer_idGROUP BY A.answer