Timeline for SQL query with GROUP BY to show badges and points by user and course
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 1, 2016 at 15:31 | vote | accept | renakre | ||
| May 1, 2016 at 14:59 | answer | added | cFreed | timeline score: 1 | |
| Apr 30, 2016 at 8:59 | comment | added | dnoeth |
That's the best you can get on MySQL, you need to access Badges twice to get the individual and the average points. Two remarks: You should add an alias to SUM(b.points) and there's no Primary Key in the BadgeAssignments table, the same user can get the same batch more than once?
|
|
| Apr 30, 2016 at 0:07 | comment | added | Phrancis | Please include your working code in the question | |
| Apr 29, 2016 at 23:44 | history | edited | 200_success | CC BY-SA 3.0 |
added 5 characters in body; edited tags; edited title
|
| Apr 29, 2016 at 23:28 | history | asked | renakre | CC BY-SA 3.0 |