Changes between Version 9 and Version 10 of ComplexReports


Ignore:
Timestamp:
04/14/26 09:02:01 (3 days ago)
Author:
221296
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • ComplexReports

    v9 v10  
    125125== 3# Annual subscription and revenue analysis by subscription plan
    126126
     127**(Year, Category_Name, Total_Attempts, Total_Students, Avg_Score, Passed_Attempts, Pass_Rate_Percentage)**
     128
    127129{{{
    128130SELECT
    … …  
    180182
    181183== 4# Yearly category analysis by attempts, students, average score, and pass rate
     184
     185**(Year, Total_Instructor_Activity, Total_Students, Total_Enrollments, Total_Attempts, Completed_Enrollments, Total_Certificates, Avg_Student_Success_Within_Courses, Avg_Final_Grade_Per_Course, Final_Year_Success)**
    182186
    183187{{{
    … …  
    282286
    283287== 5# Yearly analysis of overall platform activity and student success across enrollments, quiz attempts, completions, certificates, and course performance
     288
     289**(Year, Month, Total_Enrollments, Completed_Enrollments, Active_Instructors, Avg_Student_Success, Avg_Course_Success, Final_Month_Success)**
    284290
    285291This SQL query provides a comprehensive yearly analysis of the platform by combining multiple aspects of user activity, instructor engagement, and student performance.