MySQL: Sum () and Count in one query?
<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>