User:Jamesday/report/letter frequency
From Wikipedia, the free encyclopedia
First letter frequency for en Wikipedia, articles which aren't redirects only. 432891 of those on 17 December 2004.
select left(cur_title,1) as a, count(*)/432891*100 as b from cur where cur_is_redirect=0 and cur_namespace=0 group by a order by b desc;
+---+------+ | a | b | +---+------+ | S | 8.34 | | C | 7.43 | | M | 6.63 | | L | 6.59 | | A | 6.48 | | B | 5.96 | | T | 5.90 | | P | 5.40 | | H | 4.31 | | R | 4.24 | | D | 4.00 | | G | 3.89 | | J | 3.70 | | F | 3.45 | | E | 3.40 | | W | 3.32 | | N | 3.04 | | K | 2.40 | | I | 2.24 | | O | 1.94 | | U | 1.86 | | V | 1.49 | | 1 | 1.44 | | Y | 0.59 | | Z | 0.43 | | Q | 0.34 | | 2 | 0.27 | | X | 0.18 | | 3 | 0.12 | | 4 | 0.10 | | . | 0.08 | | 5 | 0.07 | | 7 | 0.06 | | 9 | 0.06 | | 8 | 0.06 | | 6 | 0.05 |