Skip to main content

Weighted Grad Rates

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GROUP BY GRAD_COHORT_TERM ORDER BY GRAD_COHORT_TERM' at line 14]
SELECT GRAD_COHORT_TERM, GRAD_CAMPUS, GRAD_YEARS_SINCE, SUM(GRAD_COUNT) AS TOTAL_GRADS, SUM(GRAD_INITIAL_COHORT) AS TOTAL_COHORT, ROUND( (SUM(GRAD_COUNT) / NULLIF(SUM(GRAD_INITIAL_COHORT), 0)) * 100, 2 ) AS WEIGHTED_GRAD_RATE FROM BI_TGT_CC_ASSOC_3YR_GRAD WHERE GRAD_COHORT_TERM!='Fall 2017' and GRAD_IPEDS= GROUP BY GRAD_COHORT_TERM ORDER BY GRAD_COHORT_TERM