레슨
SELECT trr.merge_study_cnt, sub.*FROM (SELECT last_total.PROGRAM1, last_total.LECTURE_NAME, last_total.TITLE,last_total.UNIT_SEQ, AVG(last_total.percent) AS study_rate ,COUNT(*) as member_cnt ,COUNT(CASE WHEN last_total.percent > 0 THEN 1 ELSE NULL END) AS study_cnt --학습자수 ,ROUND(NVL(COUNT(CASE WHEN last_total.percent > 0 THEN 1 ELSE NULL END) / NULLIF(COUNT(*),0),0) * 100,2) AS member_rate ..
2024. 7. 22.