Обчислити кількість відмінних оцінок, що отримали студенти з кожного предмету.

Question

Accepted Answer

SELECT COUNT(mark) FROM progress WHERE mark =5 GROUP BY id_subj

Accepted Answer

SELECT COUNT(*) FROM progress WHERE mark=5 GROUP BY id_subj

Answer

SELECT COUNT(*) FROM progress WHERE mark =5

Answer

SELECT COUNT(mark) FROM progress WHERE mark!=5

Answer

SELECT COUNT(*) FROM progress WHERE mark!=5 GROUP BY id_subj

Crowdly