Write a query to find the top three most popular courses in each technology category based on monthly active learners at Pluralsight.
Use the provided course and learner activity data. Include only courses with at least one identified learner activity in a month.
activity_month, technology_category, course_id, course_title, monthly_active_learners, and popularity_rank.activity_month, technology_category, and popularity_rank.| Column | Type | Description |
|---|---|---|
| course_idPK | INT | Unique course identifier |
| course_title | VARCHAR(150) | Course title shown in Pluralsight |
| technology_category | VARCHAR(80) | Technology category assigned to the course |
| Column | Type | Description |
|---|---|---|
| activity_idPK | INT | Unique learner activity record |
| course_id | INT | Course associated with the activity |
| learner_id | INT | Learner associated with the activity |
| activity_month | DATE | Month of activity, stored as the first day of the month |