public static int countStudentByGroup(int group_id) { try { return(WillORM.CountRecord("STUDENT", "SELECT COUNT(ID) from STUDENT where ID in (select STUDENT from STUDENT_GROUP_STUDENT_LIST where STUDENT_GROUP in (select ID from STUDENT_GROUP where ID = " + group_id + ")) and ACTIVE = 1")); } catch { return(0); } }