Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> select game_count, count(*), min(sigma), max(sigma) from submission where latest = 1 group by game_count order by game_count;
- +------------+----------+------------+------------+
- | game_count | count(*) | min(sigma) | max(sigma) |
- +------------+----------+------------+------------+
- | 13 | 1071 | 2.78268 | 3.58195 |
- | 14 | 407 | 2.61453 | 3.27185 |
- | 15 | 93 | 2.54569 | 3.06553 |
- | 16 | 142 | 2.43427 | 3.10605 |
- | 17 | 1020 | 2.31642 | 3.22109 |
- | 18 | 629 | 2.24334 | 3.01064 |
- | 19 | 597 | 2.18184 | 2.78888 |
- | 20 | 531 | 2.09869 | 2.78838 |
- | 21 | 438 | 2.06514 | 2.69079 |
- | 22 | 409 | 1.99826 | 2.5993 |
- | 23 | 466 | 1.9774 | 2.67527 |
- | 24 | 600 | 1.94022 | 2.54607 |
- | 25 | 526 | 1.90366 | 2.43806 |
- | 26 | 268 | 1.86555 | 2.50849 |
- | 27 | 161 | 1.85695 | 2.3071 |
- | 28 | 98 | 1.80966 | 2.22687 |
- | 29 | 93 | 1.79073 | 2.19749 |
- | 30 | 44 | 1.78177 | 2.17173 |
- | 31 | 48 | 1.73079 | 2.299 |
- | 32 | 38 | 1.71243 | 1.98362 |
- | 33 | 36 | 1.68043 | 1.96444 |
- | 34 | 32 | 1.68853 | 1.95523 |
- | 35 | 26 | 1.66979 | 1.83032 |
- | 36 | 22 | 1.62833 | 1.86394 |
- | 37 | 13 | 1.634 | 1.86225 |
- | 38 | 9 | 1.59435 | 1.79193 |
- | 39 | 11 | 1.59607 | 1.74382 |
- | 40 | 13 | 1.59284 | 1.73092 |
- | 41 | 4 | 1.55993 | 1.59024 |
- | 42 | 6 | 1.55481 | 1.57877 |
- | 43 | 3 | 1.5653 | 1.6327 |
- | 44 | 3 | 1.50285 | 1.6441 |
- | 45 | 5 | 1.53547 | 1.74176 |
- | 46 | 3 | 1.54975 | 1.56781 |
- | 47 | 2 | 1.57035 | 1.57951 |
- | 48 | 8 | 1.48537 | 1.58015 |
- | 49 | 4 | 1.46655 | 1.59097 |
- | 50 | 1 | 1.47311 | 1.47311 |
- | 51 | 2 | 1.49393 | 1.62341 |
- | 52 | 1 | 1.44712 | 1.44712 |
- | 53 | 1 | 1.44478 | 1.44478 |
- | 54 | 1 | 1.44082 | 1.44082 |
- | 55 | 2 | 1.41189 | 1.42132 |
- | 56 | 4 | 1.4071 | 1.50567 |
- | 58 | 1 | 1.55137 | 1.55137 |
- | 59 | 1 | 1.47215 | 1.47215 |
- | 60 | 1 | 1.39774 | 1.39774 |
- | 66 | 1 | 1.38836 | 1.38836 |
- | 74 | 1 | 1.3472 | 1.3472 |
- | 88 | 1 | 1.32758 | 1.32758 |
- +------------+----------+------------+------------+
- 50 rows in set (0.65 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement