msgbartop
News, views, tips and tricks on Oracle and other fun stuff
msgbarbottom

Oracle Community Membership Statistics

OracleCommunity.net

Here are some interesting statistics about the members of OracleCommunity.net:

  • Total number of members as of February 23, 2009: 4,505 members
  • Percentage of females: 13.04 %
  • Percentage of males: 86.96 %
  • Average member age: 32 years
  • Top five countries where members come from:
    1. India 30.38 %
    2. United States 26.06 %
    3. Pakistan 5.67 %
    4. United Kingdom 3.11 %
    5. Egypt 3%
  • Webmail war among Gmail, Yahoo mail and Hotmail:
    1. Gmail: 51.71 %
    2. Yahoo: 34.65 %
    3. Hotmail: 13.64 %

I calculated the above statistics by first exporting the list of members from OracleCommunity.net as a CSV file. I then used Oracle SQL developer to import the data in the CSV file into a new table in my local Oracle XE database.

sqldev_import1

I issued the following queries. The function RATIO_TO_REPORT came in handy.

Total count:

SELECT   COUNT ( * ) total_member_count FROM "oc"

TOTAL_MEMBER_COUNT     
---------------------- 
4505                   

1 rows selected

Gender:

SELECT   "Gender",
           COUNT ( * ) member_count,
           ROUND (ratio_to_report (COUNT ( * )) OVER () * 100, 2)
              member_percent
    FROM   "oc"
   WHERE   "Gender" IS NOT NULL -- Not all members provide this info
GROUP BY   "Gender"

Gender MEMBER_COUNT           MEMBER_PERCENT         
------ ---------------------- ---------------------- 
Female 442                    13.04                  
Male   2947                   86.96                  

2 rows selected

Age:

WITH ma AS (SELECT   TO_NUMBER ("Age") age
              FROM   "oc"
             WHERE   "Age" IS NOT NULL -- Not all members provide this info
               AND   TO_NUMBER ("Age") BETWEEN 18 AND 65)
SELECT   TRUNC (AVG (age)) average,
         TRUNC (STDDEV (age)) dev,
         TRUNC (VARIANCE (age)) var
  FROM   ma

AVERAGE                DEV                    VAR                    
---------------------- ---------------------- ---------------------- 
32                     7                      56                     

1 rows selected

Country:

SELECT   "Country",
           COUNT ( * ) member_count,
           ROUND (ratio_to_report (COUNT ( * )) OVER () * 100, 2)
              member_percent
    FROM   "oc"
   WHERE   "Country" IS NOT NULL -- Not all members provide this info
GROUP BY   "Country"
ORDER BY   2 DESC

Country                                    MEMBER_COUNT           MEMBER_PERCENT         
------------------------------------------ ---------------------- ---------------------- 
India                                      1034                   30.38                  
United States                              887                    26.06                  
Pakistan                                   193                    5.67                   
United Kingdom                             106                    3.11                   
Egypt                                      102                    3                      
Netherlands                                72                     2.12                   
Turkey                                     67                     1.97                   
Indonesia                                  62                     1.82                   
Canada                                     54                     1.59                   
Australia                                  53                     1.56                   
Saudi Arabia                               49                     1.44                   
United Arab Emirates                       38                     1.12                   
Singapore                                  36                     1.06                   
Germany                                    33                     0.97                   
Brazil                                     32                     0.94                   
Bangladesh                                 30                     0.88                   
Israel                                     28                     0.82                   
Italy                                      24                     0.71                   
Kuwait                                     23                     0.68                   
Mexico                                     22                     0.65                   
China, mainland                            21                     0.62                   
France                                     20                     0.59                   
Spain                                      18                     0.53                   
Malaysia                                   18                     0.53                   
Ireland                                    15                     0.44                   
Iran                                       15                     0.44                   
Argentina                                  15                     0.44                   
Thailand                                   14                     0.41                   
South Africa                               13                     0.38                   
Switzerland                                12                     0.35                   
Romania                                    12                     0.35                   
Russian Federation                         12                     0.35                   
Portugal                                   11                     0.32                   
Norway                                     11                     0.32                   
Peru                                       11                     0.32                   
Belgium                                    10                     0.29                   
Ukraine                                    9                      0.26                   
Philippines                                9                      0.26                   
Slovenia                                   9                      0.26                   
Sweden                                     8                      0.24                   
Chile                                      8                      0.24                   
Greece                                     8                      0.24                   
Czech Republic                             8                      0.24                   
Nigeria                                    7                      0.21                   
Japan                                      7                      0.21                   
Qatar                                      6                      0.18                   
Austria                                    6                      0.18                   
Ecuador                                    5                      0.15                   
Vietnam                                    5                      0.15                   
Hong Kong                                  5                      0.15                   
Poland                                     5                      0.15                   
Jordan                                     5                      0.15                   
Taiwan                                     5                      0.15                   
Kenya                                      4                      0.12                   
Denmark                                    4                      0.12                   
Slovakia                                   4                      0.12                   
Algeria                                    4                      0.12                   
Oman                                       4                      0.12                   
Botswana                                   4                      0.12                   
Iceland                                    4                      0.12                   
New Zealand                                4                      0.12                   
Serbia and Montenegro                      4                      0.12                   
Hungary                                    4                      0.12                   
Bulgaria                                   4                      0.12                   
Yemen                                      4                      0.12                   
United States Minor Outlying Islands       4                      0.12                   
Morocco                                    4                      0.12                   
Panama                                     3                      0.09                   
Colombia                                   3                      0.09                   
Sri Lanka                                  3                      0.09                   
Korea, Republic of                         3                      0.09                   
Mauritius                                  3                      0.09                   
Nepal                                      3                      0.09                   
Ghana                                      3                      0.09                   
Palestinian Territory, Occupied            3                      0.09                   
European Union                             2                      0.06                   
Iraq                                       2                      0.06                   
Azerbaijan                                 2                      0.06                   
Georgia                                    2                      0.06                   
Madagascar                                 2                      0.06                   
Costa Rica                                 2                      0.06                   
Malta                                      2                      0.06                   
Macedonia, The Former Yugoslav Republic of 2                      0.06                   
Moldova, Republic of                       1                      0.03                   
Venezuela                                  1                      0.03                   
Lithuania                                  1                      0.03                   
Papua New Guinea                           1                      0.03                   
Croatia                                    1                      0.03                   
Benin                                      1                      0.03                   
Cyprus                                     1                      0.03                   
Trinidad and Tobago                        1                      0.03                   
Dominican Republic                         1                      0.03                   
Brunei Darussalam                          1                      0.03                   
Lebanon                                    1                      0.03                   
Sudan                                      1                      0.03                   
Mozambique                                 1                      0.03                   
Senegal                                    1                      0.03                   
Finland                                    1                      0.03                   
Netherlands Antilles                       1                      0.03                   
Puerto Rico                                1                      0.03                   
Congo, The Democratic Republic Of The      1                      0.03                   
Cayman Islands                             1                      0.03                   
Uganda                                     1                      0.03                   

103 rows selected

Webmail:

SELECT   gmail,
         ROUND (gmail / (gmail + hotmail + yahoo) * 100, 2) gmail_pct,
         hotmail,
         ROUND (hotmail / (gmail + hotmail + yahoo) * 100, 2) hotmail_pct,
         yahoo,
         ROUND (yahoo / (gmail + hotmail + yahoo) * 100, 2) yahoo_pct
  FROM   (SELECT   SUM(CASE
                          WHEN INSTR ("Email", 'gmail') > 0 THEN 1
                          ELSE 0
                       END)
                      gmail,
                   SUM(CASE
                          WHEN INSTR ("Email", 'hotmail') > 0 THEN 1
                          ELSE 0
                       END)
                      hotmail,
                   SUM(CASE
                          WHEN INSTR ("Email", 'yahoo') > 0 THEN 1
                          ELSE 0
                       END)
                      yahoo
            FROM   "oc"
           WHERE   "Email" IS NOT NULL)

GMAIL        GMAIL_PCT    HOTMAIL      HOTMAIL_PCT  YAHOO        YAHOO_PCT              
------------ ------------ ------------ ------------ ------------ ------------ 
1600         51.71        422          13.64        1072         34.65                  

1 rows selected

Filed in Oracle on 24 Feb 09 | Tags: , ,


Reader's Comments

  1. |

    Wow, you’d think no one ever has email outside of gmail, yahoo or hotmail.

  2. |

    Yep, the big three web mail providers are obviously the majority of the email address domains on OC.

  3. |

    India tops the list…yeaapppieeeeeeeeeeeeeeeeeeee :)

  4. |

    wow! that mean A Male like to community more than A Female…

    ;)

  5. |

    There are usually more males than females working in the technology field. At least that has been my experience throughout my professional carrier. How many female coworkers do you have?