SELECT COUNT(*) totalStudent, c.* FROM classroom c INNER JOIN student s ON c.classID = s.classID GROUP BY c.classID
How to get zero in totalStudent? if student empty inside the classroom.
totalStudent
Aucun commentaire:
Enregistrer un commentaire