Oracle Community Membership Statistics
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:
- India 30.38 %
- United States 26.06 %
- Pakistan 5.67 %
- United Kingdom 3.11 %
- Egypt 3%
- Webmail war among Gmail, Yahoo mail and Hotmail:
- Gmail: 51.71 %
- Yahoo: 34.65 %
- 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.
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
Related articles:
- Oracle Community Update
- SQL problem
- OracleCommunity.net a Great Example of a Customer-run Community, Here is Why
Wow, you’d think no one ever has email outside of gmail, yahoo or hotmail.
Yep, the big three web mail providers are obviously the majority of the email address domains on OC.
India tops the list…yeaapppieeeeeeeeeeeeeeeeeeee
wow! that mean A Male like to community more than A Female…
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?