= Analytical and statistical querying =

== Find the Students Who Scored Below Average on Assignments ==

{{{#!sql
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);
}}}