MySQL: Calculate number using COUNT within the SELECT statement?

MySQL: Calculate number using COUNT within the SELECT statement?

References

Reference NO 1

http://stackoverflow.com/questions/607264/how-can-i-count-the-numbers-of-rows-that-a-mysql-query-returned

Reference NO 2

http://stackoverflow.com/questions/15203206/mysql-calculate-number-using-count-within-the-select-statement

Reference NO 3

http://dev.mysql.com/doc/refman/5.1/en/counting-rows.html

Reference NO 4

http://www.w3schools.com/sql/sql_func_count.asp

Reference NO 5

http://www.mysqlperformanceblog.com/2007/04/10/count-vs-countcol/

Reference NO 6

http://php.about.com/od/mysqlcommands/g/sql_count.htm

Reference NO 7

http://www.tutorialspoint.com/mysql/mysql-count-function.htm

Reference NO 8

http://www.sitepoint.com/forums/showthread.php?216548-conditional-COUNT-in-MySQL