Changes between Version 1 and Version 2 of Analytical and statistical querying


Ignore:
Timestamp:
02/10/25 01:13:23 (13 days ago)
Author:
206046
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Analytical and statistical querying

    v1 v2  
    11= Analytical and statistical querying =
     2
     3== Find the Students Who Scored Below Average on Assignments ==
     4
     5{{{#!sql
     6SELECT s.id_student, u.username, sub.progress_score
     7FROM Submission sub
     8JOIN Student s ON sub.id_student = s.id_student
     9JOIN User u ON s.id_user = u.id_user
     10WHERE sub.progress_score < (SELECT AVG(progress_score) FROM Submission);
     11}}}