You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select COUNT(Sno) as 'COUNT' from SC 
where Cno is not NULL' at line 1