Skip to content

Instantly share code, notes, and snippets.

@alexcharlie
Created October 2, 2009 19:55
Show Gist options
  • Save alexcharlie/200054 to your computer and use it in GitHub Desktop.
Save alexcharlie/200054 to your computer and use it in GitHub Desktop.
mysql> select s.name, sum(points) from skill_progresses as sp join skills as s on sp.skill_id = s.id group by sp.skill_id;
+-------------------+-------------+
| name | sum(points) |
+-------------------+-------------+
| Sabotage | 7691 |
| First Aid | 22598 |
| Vehicle Operation | 73513 |
| Fast Talk | 6500 |
| Seduction | 150121 |
| Tracking | 109792 |
| Interrogation | 87443 |
| Disguise | 8030 |
| Athletics | 63911 |
| Streetwise | 77193 |
| Hacking | 80695 |
| Demolitions | 62798 |
| Gadgetry | 83232 |
| Security | 35952 |
| Evasion | 7733 |
| Science | 27467 |
| Cryptography | 25524 |
| Class | 47515 |
| Smooth Talk | 52384 |
| Infiltration | 129627 |
+-------------------+-------------+
20 rows in set (0.12 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment