What about most NRs at once (all time, not just current)??
Fewest moves results and how often they happened:
Code:mysql> select v moves, c howOften, @sum:=ifnull(@sum,0)+c as sum FROM -> (select v, count(*) c FROM ( -> SELECT value1 v FROM Results WHERE eventId='333fm' union all -> SELECT value2 v FROM Results WHERE eventId='333fm' union all -> SELECT value3 v FROM Results WHERE eventId='333fm' union all -> SELECT value4 v FROM Results WHERE eventId='333fm' union all -> SELECT value5 v FROM Results WHERE eventId='333fm') tmp -> GROUP BY v) tmp2 -> JOIN (SELECT @sum := 0 AS dummy) dummy -> ORDER BY (v+999) % 1000 + 1; +-------+----------+-------+ | moves | howOften | sum | +-------+----------+-------+ | 22 | 2 | 2 | | 24 | 3 | 5 | | 25 | 4 | 9 | | 26 | 11 | 20 | | 27 | 24 | 44 | | 28 | 33 | 77 | | 29 | 46 | 123 | | 30 | 55 | 178 | | 31 | 71 | 249 | | 32 | 92 | 341 | | 33 | 112 | 453 | | 34 | 107 | 560 | | 35 | 130 | 690 | | 36 | 166 | 856 | | 37 | 174 | 1030 | | 38 | 146 | 1176 | | 39 | 175 | 1351 | | 40 | 154 | 1505 | | 41 | 154 | 1659 | | 42 | 157 | 1816 | | 43 | 137 | 1953 | | 44 | 143 | 2096 | | 45 | 143 | 2239 | | 46 | 129 | 2368 | | 47 | 112 | 2480 | | 48 | 110 | 2590 | | 49 | 121 | 2711 | | 50 | 81 | 2792 | | 51 | 77 | 2869 | | 52 | 82 | 2951 | | 53 | 53 | 3004 | | 54 | 49 | 3053 | | 55 | 57 | 3110 | | 56 | 39 | 3149 | | 57 | 33 | 3182 | | 58 | 19 | 3201 | | 59 | 22 | 3223 | | 60 | 28 | 3251 | | 61 | 11 | 3262 | | 62 | 11 | 3273 | | 63 | 13 | 3286 | | 64 | 13 | 3299 | | 65 | 7 | 3306 | | 66 | 9 | 3315 | | 67 | 6 | 3321 | | 68 | 4 | 3325 | | 69 | 6 | 3331 | | 70 | 5 | 3336 | | 71 | 4 | 3340 | | 72 | 1 | 3341 | | 73 | 3 | 3344 | | 75 | 2 | 3346 | | 76 | 2 | 3348 | | 77 | 2 | 3350 | | 81 | 1 | 3351 | | 87 | 1 | 3352 | | 102 | 1 | 3353 | | 127 | 1 | 3354 | | 376 | 1 | 3355 | | 535 | 1 | 3356 | | DNS | 194 | 3550 | | DNF | 2294 | 5844 | +-------+----------+-------+ 63 rows in set (0.24 sec)
More fewest moves, number of sub30s/sub31s:
Code:mysql> select count(*) successes, round(avg(moves),2) average,name FROM ( -> SELECT personId, value1 moves FROM Results WHERE eventId='333fm' union all -> SELECT personId, value2 moves FROM Results WHERE eventId='333fm' union all -> SELECT personId, value3 moves FROM Results WHERE eventId='333fm' union all -> SELECT personId, value4 moves FROM Results WHERE eventId='333fm' union all -> SELECT personId, value5 moves FROM Results WHERE eventId='333fm') tmp, -> Persons -> WHERE moves between 1 and 29 and Persons.id=personId and subId=1 -> GROUP BY personId -> ORDER BY successes desc, average, name; +-----------+---------+-------------------------------------+ | successes | average | name | +-----------+---------+-------------------------------------+ | 18 | 27.78 | Sébastien Auroux | | 7 | 26.86 | Erik Akkersdijk | | 7 | 27.43 | Clément Gallet | | 6 | 28.50 | Milán Baticz | | 5 | 27.20 | Teemu Tiinanen | | 5 | 27.80 | Daniel Sheppard | | 4 | 27.75 | Grzegorz ?uczyna | | 4 | 28.00 | Tomoaki Okayama (????) | | 3 | 27.33 | Tim Reynolds | | 3 | 27.67 | Mats Valk | | 3 | 28.00 | Arnaud van Galen | | 3 | 28.00 | Jan Bentlage | | 3 | 28.67 | Kanneti Sae Han (????????? ???????) | | 2 | 26.00 | Guus Razoux Schultz | | 2 | 27.00 | David Woner | | 2 | 27.50 | Guillain Potron | | 2 | 28.00 | Henrik Buus Aagaard | | 2 | 28.00 | Simon Westlund | | 2 | 28.50 | Loďc Petit | | 2 | 28.50 | Mirek Goljan | | 1 | 22.00 | István Kocza | | 1 | 22.00 | Jimmy Coll | | 1 | 25.00 | Baiqiang Dong (???) | | 1 | 25.00 | Ron van Bruchem | | 1 | 26.00 | Olivér Perge | | 1 | 27.00 | Claudio Müller | | 1 | 27.00 | Fang Qin (??) | | 1 | 27.00 | Michael Young | | 1 | 27.00 | Mikhail Rostovikov | | 1 | 27.00 | Stephen Adhisaputra | | 1 | 27.00 | Steven Xu | | 1 | 28.00 | Antoine Perdereau | | 1 | 28.00 | Anton Rostovikov | | 1 | 28.00 | Evgeny Akivis | | 1 | 28.00 | Jack Moseley | | 1 | 28.00 | Javier Cabezuelo Sánchez | | 1 | 28.00 | Mario Laurent | | 1 | 28.00 | Micha? Pleskowicz | | 1 | 28.00 | Nicolas Fruy | | 1 | 28.00 | Olivier Stietel | | 1 | 28.00 | Philippe Virouleau | | 1 | 28.00 | Shuang Chen (??) | | 1 | 28.00 | Zbigniew Zborowski | | 1 | 29.00 | Alexander Olleta del Molino | | 1 | 29.00 | Andres Flügel | | 1 | 29.00 | Anthony Hsu | | 1 | 29.00 | Auguste Olivry | | 1 | 29.00 | Dániel Varga | | 1 | 29.00 | Dennis Loose | | 1 | 29.00 | Hongfei Tian (???) | | 1 | 29.00 | Johannes Laire | | 1 | 29.00 | Juan Juli Andika Chandra | | 1 | 29.00 | Lorenzo Vigani Poli | | 1 | 29.00 | Sam Boyles | | 1 | 29.00 | Tobias Christlieb | | 1 | 29.00 | Vidar Klungre | | 1 | 29.00 | Yumu Tabuchi (????) | | 1 | 29.00 | Yunqi Ouyang (????) | +-----------+---------+-------------------------------------+ 58 rows in set (0.25 sec)sub31s:
Much nicer, thank you. What program did you use for that?
Mathematica 8
Code:number = {2, 0, 3, 4, 11, 24, 33, 46, 55, 71, 92, 112, 107, 130, 166, 174, 146, 175, 154, 154, 157, 137, 143, 143, 129, 112, 110, 121, 81, 77, 82, 53, 49, 57, 39, 33, 19, 22, 28, 11, 11, 13, 13, 7, 9, 6, 4, 6, 5, 4, 1, 3, 0, 2, 2, 2} ints = Table[i, {i, 22, 77}] SetOptions[BarChart, BaseStyle -> {FontSize -> 20, Bold}] BarChart[number, ChartStyle -> 60, LabelingFunction -> Above, ChartLabels -> ints, BarSpacing -> 1/5, ImageSize -> {2000}]
Bookmarks