title: MySQL: Sum () and Count in one query?
body: <p>I'm looking for help using sum() and count () in my SQL query:</p>
  
  <pre><code>select s1_s2,count(s1_s2) as RES 
  from city_user 
  where s1_s2 in (select s1_s2 from city_user ) 
  group by s1_s2
  </code></pre>
  
  <p>result: <a href="http://i.stack.imgur.com/DERnL.png" rel="nofollow">Image Query Result </a></p>
  
  <p>I want to make  sum () for RES column </p>
  
  <p>Is that possible?</p>