Трюк дня. Количество повторений значения в столбце в SQL.

SELECT group_id, Count(student_id) FROM students WHERE group_id>0 GROUP BY students.group_id HAVING COUNT (student_id)<(?) ORDER BY students.group_id;

#tips