Courses with average rating (10+ ratings only)
Courses with average rating (10+ ratings only)
Skypro's content team tests new courses and wants the landing page to surface only those with statistically meaningful feedback — at least 10 ratings. Archived courses (is_published = FALSE) are out.
For published courses with at least ten ratings, compute the average and round it to 2 decimals. Skip the archived ones.
Expected output sample
| course_name | avg_rating |
|---|---|
| SQL Intensive | 4.82 |
| Python Basics | 4.45 |
Skypro
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid