From 289d5a1a6d6997722f35b7f7303c7b3ce9afffa4 Mon Sep 17 00:00:00 2001
From: Navan Chauhan <navanchauhan@gmail.com>
Date: Thu, 4 Jan 2024 19:04:03 +0530
Subject: show average grades for class

---
 index.html | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/index.html b/index.html
index 201bee2..1ead0d4 100644
--- a/index.html
+++ b/index.html
@@ -233,7 +233,7 @@
                 grade = ">= 0";
             }
 
-            let query = `SELECT DISTINCT Subject || ' ' || Course AS "Class Code", CourseTitle as "Title", AVG(AVG_GRD) AS "Average Grade"  FROM raw_data WHERE  (CrsPBADiv = '${division}' AND COURSE ${grade} ) AND Subject != 'APPM'  GROUP BY "Class Code", "Title"`
+            let query = `SELECT DISTINCT Subject || ' ' || Course AS "Class Code", CourseTitle as "Title", AVG(AVG_GRD) AS "Average Grade", AVG(PCT_A) as "% A", AVG(PCT_B) as "% B", AVG(PCT_C_MINUS_OR_BELOW) as "% C- and below", AVG(N_GRADE) as "No. Graded"  FROM raw_data WHERE  (CrsPBADiv = '${division}' AND COURSE ${grade} ) AND Subject != 'APPM'  GROUP BY "Class Code", "Title"`
 
             console.log(query);
 
-- 
cgit v1.2.3