Analytical and statistical querying

Find the Students Who Scored Below Average on Assignments

SELECT s.id_student, u.username, sub.progress_score
FROM Submission sub
JOIN Student s ON sub.id_student = s.id_student
JOIN User u ON s.id_user = u.id_user
WHERE sub.progress_score < (SELECT AVG(progress_score) FROM Submission);