alexcharlie

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 | 

alexcharlie

mysql> select s.name, sum(sp.points), RPAD('', sum(sp.points) / 1000, '#') as bar 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) | bar                                                                                                        |
+-------------------+----------------+------------------------------------------------------------------------------------------------------------+
| Sabotage          |           2411 | ##                                                                                                         | 
| First Aid         |          16928 | #################                                                                                          | 
| Vehicle Operation |          27540 | #################

alexcharlie

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 | *                       | 

alexcharlie

869,2404,4345,200243,202359,203837,205136,207440,207559,207611,209174,209730,213586,215181,217754,219284,219492,219493,223761,502666,600487,601185,601901,603674,609483,612438,615860,700103,700240,800689,803245,814970,1200006,1200246,1200725,1200752,1200849,1202610,1203227,1203598,1205541,1207654,1207872,1210682,1214419,1214528,1218568,1230847,1232224,1232388,1232755,1236081,1238868,1240564,1502940,1506714,1511767,1514587,1800314,1807232,2202051,2240416,2249669,2502436,2502602,2502884,2503524,2504551,2505786,2505831,2508781,2509183,2511398,2511713,2513224,2514353,2516452,2519107,2527190,2528404,2534093,2537863,2729569,2900395,2900526,2900569,2900959,2901163,2902027,3006114,3200218,3202669,3205241,3212719,3222650,3300204,3300229,3300252,3300572,3300806,3302115,3302165,3302239,3302807,3303055,3303365,3304784,3305987,3307657,3307727,3308164,3309010,3309089,3310562,3310571,3313554,3313959,3318165,3318322,3318369,3326963,3400087,3400171,3401111,3409473,3416311,3502094,3701126,3900570,4100641,4709556,4800072,4800233