How many girls average sub25?

The WCA database is incomplete concerning gender, but there are 24 competitors with a sub25 average marked as female. And 13 with sub20, which btw conveniently gets rid of Fridrich. And two with sub15. The youngest sub20 girl is 11 years old, btw.
 
I'm a girl cuber who can get a sub 20 average...
But I haven't been to any competitions yet :(
 
Does nobody here remember Casey Pernsteiner? She quit updating her averages (or quit cubing) but in April 2006 she posted a 13.31 average. She was one of the fastest (male or female) during those days.
 
Uh oh, I'm dangerous with a relational database. Thanks to Ron for making it available.

The answer is 47.

Code:
mysql> select person.name, person.countryId,  
       round(min(average)/100, 2) as time 
       from result 
       join person on result.personId = person.id  
       where gender = 'f' and eventId = '333' 
       and average > 0 and average <= 2500  
       group by person.name, person.countryId  
       order by min(average) ; 
+--------------------------+----------------+-------+
| name                     | countryId      | time  |
+--------------------------+----------------+-------+
| Son Seul-Gi              | Korea          | 13.56 | 
| Moe Nakano               | Japan          | 13.82 | 
| Emily Wang               | Canada         | 14.17 | 
| Paik Seung-Won           | Korea          | 14.69 | 
| Brittany Dzoan           | USA            | 15.15 | 
| Sarah Strong             | Canada         | 15.17 | 
| Kristine Doctor          | Philippines    | 15.93 | 
| Yukiko Makino            | Japan          | 16.04 | 
| Surin Ahn                | USA            | 16.63 | 
| Irène Mallordy           | France         | 16.63 | 
| Shelley Chang            | USA            | 16.63 | 
| Yu Araki                 | Japan          | 16.77 | 
| Casey Pernsteiner        | USA            | 16.81 | 
| Deseree Aune             | Canada         | 16.98 | 
| Aili Asikainen           | Finland        | 17.48 | 
| Ambie Valdés             | USA            | 17.82 | 
| Ximiao Liu               | China          | 17.86 | 
| Stephanie Chow           | USA            | 18.10 | 
| Beac Seo-Jin             | Korea          | 18.12 | 
| Pantita Sandusadee       | Thailand       | 18.14 | 
| Laetitia Lemoine         | France         | 18.46 | 
| Sesi Cadmus              | USA            | 18.88 | 
| Gina Uy                  | Philippines    | 19.23 | 
| Junko Ootsu              | Japan          | 20.33 | 
| Jessica Fridrich         | USA            | 20.48 | 
| Jessica Fridrich         | Czech Republic | 20.48 | 
| Mika Muranushi           | Japan          | 20.86 | 
| Yu-Hsin Huang            | Taiwan         | 20.95 | 
| Christine Anne Flordeliz | Philippines    | 21.21 | 
| Connie Chen              | USA            | 21.40 | 
| Yu Da-Hyun               | Korea          | 21.54 | 
| Shin Hyo-Eun             | Korea          | 21.56 | 
| Tianshu Wang             | China          | 21.57 | 
| Nattharin Panyasakulwong | Thailand       | 22.49 | 
| Yaoxi Li                 | China          | 22.66 | 
| Luojin Xu                | China          | 22.74 | 
| Monika Zimmermann        | Germany        | 22.77 | 
| Tawanporn Laovanichvit   | Thailand       | 23.07 | 
| Sin Ye-Jin               | Korea          | 23.27 | 
| Charlie Cooper           | United Kingdom | 23.35 | 
| Men-Shing Lin            | Taiwan         | 23.53 | 
| Seo Jeong-Min            | Korea          | 23.99 | 
| Jordan Mannfeld          | USA            | 24.06 | 
| Karolina Wiacek          | Poland         | 24.10 | 
| Marlène Desmaisons       | France         | 24.40 | 
| Barbara Olbromska        | Poland         | 24.43 | 
| Monique Alivio           | Philippines    | 24.82 | 
| Jeanne Ayame Kurotuti    | Brazil         | 24.85 | 
+--------------------------+----------------+-------+
48 rows in set (0.10 sec)
 
Back
Top