Hello there, hope in your help.

I need extract from my mysql table the results of an online poll.

The questions:
  • I speak only English Yes No
  • I speak only Spanish Yes No
  • I speak English and a little bit of Spanish Yes No
  • I speak Spanish and a little bit of English Yes No
  • I speak English as well as Spanish Yes No

I tried this query:
Code:
SELECT
	SUM(

		IF (
			I_speak_only_English = "Yes",
			1,
			0
		)
	) AS `only_English`
	COUNT(*) AS `total`
FROM
	tbl_poll
GROUP BY
	names
ORDER BY
	names DESC
But how do we count the answer with "No"?
Please tell me how to resolve this problem ...
thank you