Skip to content

Instantly share code, notes, and snippets.

@alexcharlie
Created October 2, 2009 20:03
Show Gist options
  • Save alexcharlie/200067 to your computer and use it in GitHub Desktop.
Save alexcharlie/200067 to your computer and use it in GitHub Desktop.
mysql> select s.name, sum(sp.points) from (skill_progresses as sp join users as u on sp.user_id = u.id) join skills s on sp.skill_id = s.id where u.level > 10 group by sp.skill_id;
+-------------------+----------------+
| name | sum(sp.points) |
+-------------------+----------------+
| Sabotage | 2411 |
| First Aid | 16918 |
| Vehicle Operation | 27540 |
| Fast Talk | 1060 |
| Seduction | 105563 |
| Tracking | 52910 |
| Interrogation | 41314 |
| Disguise | 2750 |
| Athletics | 17998 |
| Streetwise | 35472 |
| Hacking | 66076 |
| Demolitions | 16834 |
| Gadgetry | 41622 |
| Security | 30689 |
| Evasion | 2453 |
| Science | 21817 |
| Cryptography | 19876 |
| Class | 42151 |
| Smooth Talk | 46637 |
| Infiltration | 83446 |
+-------------------+----------------+
20 rows in set (0.04 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment