SELECT COUNT(id_alumno) AS cantidad, id_alumno
FROM tbl_alumnos
WHERE (
comuna='uno' AND comuna='dos' AND comuna='cuatro' AND comuna='cinco' AND comuna='seis' AND comuna='siete')

SELECT COUNT(id_alumno) AS cantidad
FROM tbl_alumnos
GROUP BY comuna