SELECT COUNT Abfrage aus zwei Tabellen in sql

Ich habe diese Frage

SELECT ( SELECT COUNT( answer ) FROM Voters WHERE answer = 'Yes' ), ( SELECT COUNT(answer) FROM Voters WHERE answer = 'No' ), question, date, image FROM Poll, Voters WHERE Poll.poll_id = Voters.poll_id 

und ich empfange dieses wiederholende Ergebnis, wie bekomme ich eine eindeutige Zeile? Ich möchte das erreichen:

 Yes|No|Question|date|image 2 |1 | ques |date| img 

Bildbeschreibung hier eingeben

 SELECT SUM(CASE WHEN answer = 'yes' THEN 1 ELSE 0 END) "Yes", SUM(CASE WHEN answer = 'no' THEN 1 ELSE 0 END) "NO", question, date, image FROM Poll p INNER JOIN Voters v ON p.poll_id = v.poll_id GROUP BY question, date, image 

Versuchen

 SELECT distinct question, date, image,( SELECT COUNT( answer ) FROM Voters WHERE answer = 'Yes' ), ( SELECT COUNT(answer) FROM Voters WHERE answer = 'No' ) FROM Poll, Voters WHERE Poll.poll_id = Voters.poll_id