Skip to content

Instantly share code, notes, and snippets.

@alexcharlie
Created October 2, 2009 20:14
Show Gist options
  • Save alexcharlie/200073 to your computer and use it in GitHub Desktop.
Save alexcharlie/200073 to your computer and use it in GitHub Desktop.
mysql> select s.name, count(*), RPAD('', count(*), '*') from skill_rewards as sr join skills as s on sr.skill_id = s.id group by sr.skill_id;
+-------------------+----------+-------------------------+
| name | count(*) | RPAD('', count(*), '*') |
+-------------------+----------+-------------------------+
| Sabotage | 1 | * |
| First Aid | 1 | * |
| Vehicle Operation | 2 | ** |
| Seduction | 3 | *** |
| Tracking | 2 | ** |
| Interrogation | 1 | * |
| Disguise | 1 | * |
| Athletics | 2 | ** |
| Streetwise | 2 | ** |
| Hacking | 4 | **** |
| Demolitions | 2 | ** |
| Gadgetry | 1 | * |
| Security | 2 | ** |
| Evasion | 1 | * |
| Science | 1 | * |
| Cryptography | 1 | * |
| Class | 2 | ** |
| Smooth Talk | 3 | *** |
| Infiltration | 3 | *** |
+-------------------+----------+-------------------------+
19 rows in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment