<div>
it doesn't show any result.<br />
<br />
Error message:<br />
&quot;Function Sum does not exist;&quot;
</div>


it doesn't show any result.

Error message:
"Function Sum does not exist;"

<div>
<div class="content wysiwyg-content">
Dear Experts,<br />
<br />
I have a table( id, duration) and its data are as follows:<br />
<br />
id &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;duration<br />
= &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;=====<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0<br />
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5<br />
3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0<br />
4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1<br />
5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2<br />
6 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9<br />
<br />
I want a result by SQL query with the following two fields:<br />
Count(duration only 0) &nbsp; Count(duration not 0)<br />
============== &nbsp; ==============<br />
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4<br />
<br />

</div>
</div>


Dear Experts,

I have a table( id, duration) and its data are as follows:

id          duration
=          =====
1           0
2           5
3           0
4           1
5           2
6           9

I want a result by SQL query with the following two fields:
Count(duration only 0)   Count(duration not 0)
==============   ==============
2                                 4



Count Field in SQL

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.