title: mysql join two tables, count and sum alias
body: <p>I have query </p>
  
  <pre><code>SELECT p. * , COUNT( r.poll_option_id ) AS voteCount
  FROM poll_options AS p
  LEFT JOIN poll_responses AS r ON ( r.poll_option_id = p.id ) 
  WHERE p.poll_id =1
  GROUP BY p.id
  LIMIT 0 , 30
  </code></pre>
  
  <p>It returns me this data which is correct </p>
  
  <pre><code> id poll_id caption voteCount   
   1  1   32  1
   2  1   256 1
   3  1   512 0
  </code></pre>
  
  <p>Now I need to count that alias voteCount, so for this example it would be 1+1+0=2.. And return it as another alias. How could I do it? I must use only 1 query, and I do not have rights to edit database. I have tried examples from 
  <a href="https://stackoverflow.com/questions/15387808/mysql-join-two-tables-count-and-sum-from-second-table">MySQL Join two tables count and sum from second table</a> 
  <a href="https://stackoverflow.com/questions/16281892/mysql-query-count-and-sum-with-two-joined-tables">MySQL query, COUNT and SUM with two joined tables</a>
  and couple more
  but no luck..</p>