<div>
<div class="content wysiwyg-content">
SELECT `Ssurname` <br />
, SUM(CASE WHEN ((`status`= '11' ) or &nbsp;(`status`= '12' ) ) THEN 1 ELSE 0 END) as Rows_Status_11<br />
, SUM(CASE WHEN ((`status`!= '11' ) AND(`status`!= '12' ) ) THEN 1 ELSE 0 END) as Rows_Status_not_11,(select<wbr /> &nbsp;count(*) as tol where ( (`status`= '11' ) or &nbsp;(`status`= '12' )) form member_copy1 )<br />
from member_copy1 <br />
GROUP BY `Ssurname` <br />
Order by Rows_Status_11 Desc<br />
<br />
sql above is not work please help to correct it <br />
<br />
may be (select &nbsp;count(*) as tol where ( (`status`= '11' ) or &nbsp;(`status`= '12' )) form member_copy1 ) is not correct
</div>
</div>


SELECT `Ssurname` 
, SUM(CASE WHEN ((`status`= '11' ) or  (`status`= '12' ) ) THEN 1 ELSE 0 END) as Rows_Status_11
, SUM(CASE WHEN ((`status`!= '11' ) AND(`status`!= '12' ) ) THEN 1 ELSE 0 END) as Rows_Status_not_11,(select  count(*) as tol where ( (`status`= '11' ) or  (`status`= '12' )) form member_copy1 )
from member_copy1 
GROUP BY `Ssurname` 
Order by Rows_Status_11 Desc

sql above is not work please help to correct it 

may be (select  count(*) as tol where ( (`status`= '11' ) or  (`status`= '12' )) form member_copy1 ) is not correct

sql statement for count in mysql

SELECT `Ssurname` 
, SUM(CASE WHEN ((`status`= &#39;11&#39; ) or  (`status`= &#39;12&#39; ) ) THEN 1 ELSE 0 END) as Rows_Status_11
, SUM(CASE WHEN ((`status`!= &#39;11&#39; ) AND(`status`!= &#39;12&#39; ) ) THEN 1 ELSE 0 END) as Rows_Status_not_11,(select  count(*) as tol where ( (`status`= &#39;11&#39; ) or  (`status`= &#39;12&#39; )) form member_copy1 )
from member_copy1 
GROUP BY `Ssurname` 
Order by Rows_Status_11 Desc

sql above is not work please help to correct it 

may be (select  count(*) as tol where ( (`status`= &#39;11&#39; ) or  (`status`= &#39;12&#39; )) form member_copy1 ) is not correct

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.

MySQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.