WITH base AS( SELECT a.user_id, a.course_id, ROUND(AVG(b.rating),2) AS average_rating, CASE WHEN ROUND(AVG(b.rating),2)>=4.0 THEN '优质反馈学员' ELSE '普通反馈学员' END AS feedback_type FROM course_completions a JOIN content_reviews b ON a.user_id=b.user_id WHERE b.review_date>='2025-03-01' AND b.review_d...
