select count(*) "total vote",vote from poll_result pr, add_poll ap where ap.id=pr.id and pr.id=@id group by vote