Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 The Yak Corral
 World Wide SQL

Author  Topic 

JimL
SQL Slinging Yak Ranger

1537 Posts
Posted - 2004-10-06 : 09:56:08
Now many Countries do SQL Team members represent.

Select distinct Country
Into #tempCountry
From SQLTeam

Select Count(*) As Number_of_Countries
From #tempCountry

Drop Table #tempCountry

We really need at least one in every Country.

How else will we achieve world wide domination?

Well its better than TEST. LOL






Jim
Users <> Logic

Amethystium
Aged Yak Warrior

701 Posts
Posted - 2004-10-06 : 10:18:13
You must be very bored Jim. Go for a smoke or something, or maybe do some work Your day has just started!!!!!

Oh and by the way, I'm from Garden of Sakuntala. Bet you won't find many people from there


------------->>> BREAKING NEWS!!! <<<-------------
Saddam Hussien has weapons of mass destrcution
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts
Posted - 2004-10-06 : 10:19:51
Amethystium, as far as i know u're from uk, no?

haven't seen anyone from nepal...

Go with the flow & have fun! Else fight the flow
Go to Top of Page

Amethystium
Aged Yak Warrior

701 Posts
Posted - 2004-10-06 : 10:27:06
How did Garden of Sakuntala get in there though


------------->>> BREAKING NEWS!!! <<<-------------
Saddam Hussien has weapons of mass destrcution
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts
Posted - 2004-10-06 : 10:53:47
i don't know?? by camels??

Go with the flow & have fun! Else fight the flow
Go to Top of Page

graz
Chief SQLTeam Crack Dealer

4149 Posts
Posted - 2004-10-06 : 10:58:40
How about this query:

SELECT M_COUNTRY, COUNT(*)
FROM FORUM_MEMBERS
GROUP BY M_COUNTRY
ORDER BY 2 DESC, 1 ASC


(I don't see a table of valid countries so I don't know who we're missing. I think those values are hard coded into the forum application itself.)

And the result:


M_COUNTRY                                                      
-------------------------------------------------- ----------- 
                                                   7536
USA                                                1821
India                                              870
United Kingdom                                     511
Canada                                             192
NULL                                               169
Australia                                          165
Netherlands                                        91
South Africa                                       84
Malaysia                                           60
Pakistan                                           59
Sweden                                             59
Philippines                                        57
Brazil                                             51
Indonesia                                          46
Germany                                            41
Italy                                              38
Mexico                                             36
New Zealand                                        36
Belgium                                            32
Turkey                                             32
Israel                                             31
Singapore                                          30
France                                             28
Ireland                                            25
Romania                                            25
Russia                                             25
Spain                                              25
Portugal                                           24
United Arab Emirates                               24
Iran                                               23
Vietnam                                            21
Egypt                                              20
Norway                                             20
Denmark                                            19
China                                              18
Thailand                                           15
Peru                                               14
Saudi Arabia                                       14
Austria                                            12
Switzerland                                        12
Costa Rica                                         10
Greece                                             10
Hong Kong                                          10
Argentina                                          9
Chile                                              9
Venezuela                                          9
Finland                                            8
Nigeria                                            8
Poland                                             8
Colombia                                           7
Czech Republic                                     7
Jordan                                             7
Sri Lanka                                          7
Ukraine                                            7
Japan                                              6
Iceland                                            5
Kenya                                              5
Albania                                            4
Bangladesh                                         4
Bolivia                                            4
Bulgaria                                           4
Croatia                                            4
Guatemala                                          4
Hungary                                            4
Jamaica                                            4
Lithuania                                          4
Anguilla                                           3
Estonia                                            3
Kuwait                                             3
Moldova                                            3
Morocco                                            3
Myanmar (Burma)                                    3
Nepal                                              3
Slovenia                                           3
Taiwan                                             3
Uganda                                             3
Zimbabwe (Rhodesia)                                3
Andorra                                            2
Barbados                                           2
Belarus                                            2
Bermuda                                            2
Bosnia and Herzegovina                             2
Cambodia                                           2
Dominican Republic                                 2
Ecuador                                            2
Ghana                                              2
Iraq                                               2
Kazakhstan                                         2
Korea                                              2
Latvia                                             2
Luxembourg                                         2
Malta                                              2
Mauritius                                          2
Mongolia                                           2
Qatar                                              2
Syria                                              2
Tanzania                                           2
Yugoslavia                                         2
Zambia                                             2
Afghanistan                                        1
Algeria                                            1
Armenia                                            1
Bahrain                                            1
Cuba                                               1
Cyprus                                             1
Eritria                                            1
Falkland Islands                                   1
Fed Rep Yugoslavia                                 1
Fiji                                               1
Fyro Macedonia                                     1
Garden of Sakuntala                                1
Georgia                                            1
Lebanon                                            1
Macao                                              1
Namibia                                            1
Oman                                               1
Papua New Guinea                                   1
Republic of Korea                                  1
Seychelles                                         1
Slovakia                                           1
Sudan                                              1
Trinidad and Tobago                                1
Uruguay                                            1
USSR                                               1
Wallis and Futuna Islands                          1

(126 row(s) affected)


===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts
Posted - 2004-10-06 : 11:13:32
only 3 from slovenia... i'm disapointed....
and 3 from nepal... that's great!


Go with the flow & have fun! Else fight the flow
Go to Top of Page

samsekar
Constraint Violating Yak Guru

437 Posts
Posted - 2004-10-06 : 11:39:13
Hurray! India is in Second Position !

- Sekar
Go to Top of Page

JimL
SQL Slinging Yak Ranger

1537 Posts
Posted - 2004-10-06 : 12:38:42
Ok 125 out of 191 Thats 65% not a bad start.

Amethystium

I have 16 active projects and every one of them is waiting on someone else, for once.

I quit smoking 7 years ago and dont miss it one bit.


Jim
Users <> Logic
Go to Top of Page

X002548
Not Just a Number

15586 Posts
Posted - 2004-10-06 : 13:08:35
quote:
Originally posted by JimL

I quit smoking 7 years ago and dont miss it one bit.


Ummm...wrong "product"



Brett

8-)
Go to Top of Page

JimL
SQL Slinging Yak Ranger

1537 Posts
Posted - 2004-10-06 : 15:23:15
Your Baaaaaaaddddddd Brett!

Jim
Users <> Logic
Go to Top of Page

Amethystium
Aged Yak Warrior

701 Posts
Posted - 2004-10-07 : 06:41:05
quote:

I have 16 active projects and every one of them is waiting on someone else, for once.

I quit smoking 7 years ago and dont miss it one bit.


Why do people take things the wrong way?! Jim, it was intended as a joke anyway.

Good on you for giving up the smoking. I've cut down big style and I'm averaging 4-5 a day (which is still bad but better than 20-30).



------------->>> BREAKING NEWS!!! <<<-------------
Saddam Hussien has weapons of mass destrcution
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts
Posted - 2004-10-07 : 10:23:11
ok here are all world countries 


declare @Countries table(name varchar(50))
insert into @Countries
select 'Afghanistan' UNION ALL
select 'Albania' UNION ALL
select 'Algeria' UNION ALL
select 'Andorra' UNION ALL
select 'Angola' UNION ALL
select 'Antigua and Barbuda' UNION ALL
select 'Argentina' UNION ALL
select 'Armenia' UNION ALL
select 'Australia' UNION ALL
select 'Austria' UNION ALL
select 'Azerbaijan' UNION ALL 
select 'Bahamas' UNION ALL
select 'Bahrain' UNION ALL
select 'Bangladesh' UNION ALL
select 'Barbados' UNION ALL
select 'Belarus' UNION ALL
select 'Belgium' UNION ALL
select 'Belize' UNION ALL
select 'Benin' UNION ALL
select 'Bhutan' UNION ALL
select 'Bolivia' UNION ALL
select 'Bosnia and Herzegovina' UNION ALL
select 'Botswana' UNION ALL
select 'Brazil' UNION ALL
select 'Brunei Darussalam' UNION ALL
select 'Bulgaria' UNION ALL
select 'Burkina Faso' UNION ALL
select 'Burma (Myanmar)' UNION ALL
select 'Burundi' UNION ALL
select 'Cambodia' UNION ALL
select 'Cameroon' UNION ALL
select 'Canada' UNION ALL
select 'Cape Verde' UNION ALL
select 'Central African Republic' UNION ALL
select 'Chad Chile' UNION ALL
select 'China' UNION ALL
select 'Colombia' UNION ALL
select 'Comoros' UNION ALL
select 'Congo' UNION ALL
select 'Costa Rica' UNION ALL
select 'Côte d''Ivoire' UNION ALL
select 'Croatia' UNION ALL
select 'Cuba' UNION ALL
select 'Cyprus' UNION ALL
select 'Czech Republic' UNION ALL
select 'Denmark' UNION ALL
select 'Djibouti' UNION ALL
select 'Dominica' UNION ALL
select 'Dominican Republic' UNION ALL
select 'East Timor' UNION ALL
select 'Ecuador' UNION ALL
select 'Egypt' UNION ALL
select 'El Salvador' UNION ALL
select 'England (U.K.)' UNION ALL
select 'Equatorial Guinea' UNION ALL
select 'Eritrea' UNION ALL
select 'Estonia' UNION ALL
select 'Ethiopia' UNION ALL
select 'Fiji' UNION ALL
select 'Finland' UNION ALL
select 'France' UNION ALL
select 'Gabon' UNION ALL
select 'Gambia' UNION ALL
select 'Georgia' UNION ALL
select 'Germany' UNION ALL
select 'Ghana' UNION ALL
select 'Great Britain (U.K.)' UNION ALL
select 'Greece' UNION ALL
select 'Grenada Guatemala' UNION ALL
select 'Guinea' UNION ALL
select 'Guinea-Bissau' UNION ALL
select 'Guyana' UNION ALL
select 'Haiti' UNION ALL
select 'Honduras' UNION ALL
select 'Hungary' UNION ALL
select 'Iceland' UNION ALL
select 'India' UNION ALL
select 'Indonesia' UNION ALL
select 'Iran' UNION ALL
select 'Iraq' UNION ALL
select 'Ireland' UNION ALL
select 'Israel' UNION ALL
select 'Italy' UNION ALL
select 'Jamaica' UNION ALL
select 'Japan' UNION ALL
select 'Jordan' UNION ALL
select 'Kazakhstan' UNION ALL
select 'Kenya' UNION ALL
select 'Kiribati' UNION ALL
select 'Korea, North' UNION ALL
select 'Korea, South' UNION ALL  
select 'Kuwait' UNION ALL
select 'Kyrgyzstan' UNION ALL
select 'Laos' UNION ALL
select 'Latvia' UNION ALL
select 'Lebanon' UNION ALL
select 'Lesotho' UNION ALL
select 'Liberia' UNION ALL
select 'Libya' UNION ALL
select 'Liechtenstein' UNION ALL
select 'Lithuania' UNION ALL
select 'Luxembourg' UNION ALL
select 'Macedonia' UNION ALL
select 'Madagascar' UNION ALL
select 'Malawi' UNION ALL
select 'Malaysia' UNION ALL
select 'Maldives' UNION ALL
select 'Mali' UNION ALL
select 'Malta' UNION ALL
select 'Marshall Islands' UNION ALL
select 'Mauritania' UNION ALL
select 'Mauritius' UNION ALL
select 'Mexico' UNION ALL
select 'Micronesia' UNION ALL
select 'Moldova' UNION ALL
select 'Monaco' UNION ALL
select 'Mongolia' UNION ALL
select 'Morocco' UNION ALL
select 'Mozambique' UNION ALL
select 'Myanmar' UNION ALL
select 'Namibia' UNION ALL
select 'Nauru' UNION ALL
select 'Nepal' UNION ALL
select 'The Netherlands' UNION ALL
select 'New Zealand' UNION ALL
select 'Nicaragua' UNION ALL
select 'Niger' UNION ALL
select 'Nigeria' UNION ALL
select 'Northern Ireland (U.K.)' UNION ALL
select 'Norway' UNION ALL
select 'Oman' UNION ALL
select 'Pakistan' UNION ALL
select 'Palau' UNION ALL
select 'Palestinian State' UNION ALL
select 'Panama' UNION ALL
select 'Papua New Guinea' UNION ALL
select 'Paraguay' UNION ALL
select 'Peru' UNION ALL
select 'The Philippines' UNION ALL
select 'Poland' UNION ALL
select 'Portugal' UNION ALL
select 'Qatar' UNION ALL
select 'Romania' UNION ALL
select 'Russia' UNION ALL
select 'Rwanda' UNION ALL
select 'St. Kitts and Nevis' UNION ALL
select 'St. Lucia' UNION ALL
select 'St. Vincent and The Grenadines' UNION ALL
select 'Samoa' UNION ALL
select 'San Marino' UNION ALL
select 'Sao Tomé and Príncipe' UNION ALL
select 'Saudi Arabia' UNION ALL
select 'Scotland (U.K.)' UNION ALL
select 'Senegal' UNION ALL
select 'Serbia and Montenegro' UNION ALL
select 'Seychelles' UNION ALL
select 'Sierra Leone' UNION ALL
select 'Singapore' UNION ALL
select 'Slovakia' UNION ALL
select 'Slovenia' UNION ALL
select 'Solomon Islands' UNION ALL
select 'Somalia' UNION ALL
select 'South Africa' UNION ALL
select 'Spain' UNION ALL
select 'Sri Lanka' UNION ALL
select 'Sudan' UNION ALL
select 'Suriname' UNION ALL
select 'Swaziland' UNION ALL
select 'Sweden' UNION ALL
select 'Switzerland' UNION ALL
select 'Syria' UNION ALL
select 'Taiwan' UNION ALL
select 'Tajikistan' UNION ALL
select 'Tanzania' UNION ALL
select 'Thailand' UNION ALL
select 'Togo' UNION ALL
select 'Tonga' UNION ALL
select 'Trinidad and Tobago' UNION ALL
select 'Tunisia' UNION ALL
select 'Turkey' UNION ALL
select 'Turkmenistan' UNION ALL
select 'Tuvalu' UNION ALL
select 'Uganda' UNION ALL
select 'Ukraine' UNION ALL
select 'United Arab Emirates' UNION ALL
select 'United Kingdom' UNION ALL
select 'United States' UNION ALL
select 'Uruguay' UNION ALL
select 'Uzbekistan' UNION ALL
select 'Vanuatu' UNION ALL
select 'Vatican City' UNION ALL
select 'Venezuela' UNION ALL
select 'Vietnam ' UNION ALL
select 'Wales (U.K.)' UNION ALL
select 'Western Sahara' UNION ALL
select 'Yemen' UNION ALL
select 'Yugoslavia' UNION ALL
select 'Zaire' UNION ALL
select 'Zambia'

select name from @Countries


Go with the flow & have fun! Else fight the flow
Go to Top of Page

Wanderer
Master Smack Fu Yak Hacker

1168 Posts
Posted - 2004-10-07 : 11:05:04
Only 199 countries? That means we are doing quite well :

Number Undominated Countries
----------------------------
95

Dominated Unknown Counties
--------------------------
20





*##* *##* *##* *##*

Chaos, Disorder and Panic ... my work is done here!
Go to Top of Page

Arnold Fribble
Yak-finder General

1961 Posts
Posted - 2004-10-07 : 11:58:50
There are some suspect (and some outright wrong) items on that list:

select 'Burma (Myanmar)' UNION ALL
select 'Chad Chile' UNION ALL
select 'England (U.K.)' UNION ALL
select 'Great Britain (U.K.)' UNION ALL
select 'Grenada Guatemala' UNION ALL
select 'Myanmar' UNION ALL
select 'Northern Ireland (U.K.)' UNION ALL
select 'Scotland (U.K.)' UNION ALL
select 'United Kingdom' UNION ALL
select 'Wales (U.K.)' UNION ALL

Presumably Zimbabwe fell off the bottom?
Go to Top of Page

X002548
Not Just a Number

15586 Posts
Posted - 2004-10-07 : 13:05:11
You forgot Texas....well ain't least they think so...

And what about California...no wait, that would be another planet...



Brett

8-)
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts
Posted - 2004-10-07 : 13:06:30
quote:
Originally posted by X002548


And what about California...no wait, that would be another planet...





Tara
Go to Top of Page

Seventhnight
Master Smack Fu Yak Hacker

2878 Posts
Posted - 2004-10-07 : 13:53:57
Hey, how would the countries rank if you counted the number of posts by a member of each company?

Or maybe the average number of posts for a user in a given country?
(although I think the all of the onesies and twosies would screw that up)

Corey
Go to Top of Page

graz
Chief SQLTeam Crack Dealer

4149 Posts
Posted - 2004-10-07 : 19:52:27
You would ask wouldn't you?


SELECT M_COUNTRY, 
	COUNT(*) AS MEMBERS, 
	SUM(M_POSTS) AS TOTAL_POSTS,
	CAST(sum(M_POSTS) * 1.0 / COUNT(*) * 1.0 AS DECIMAL(6,1)) AS POSTS_PER_MEMBER
FROM FORUM_MEMBERS
GROUP BY M_COUNTRY
ORDER BY 3 DESC, 2 DESC


SELECT M_COUNTRY, 
	COUNT(*) AS MEMBERS, 
	SUM(M_POSTS) AS TOTAL_POSTS,
	CAST(sum(M_POSTS) * 1.0 / COUNT(*) * 1.0 AS DECIMAL(6,1)) AS POSTS_PER_MEMBER
FROM FORUM_MEMBERS
GROUP BY M_COUNTRY
ORDER BY 4 DESC, 3 DESC, 2 DESC




M_COUNTRY                                          MEMBERS     TOTAL_POSTS POSTS_PER_MEMBER 
-------------------------------------------------- ----------- ----------- ---------------- 
USA                                                1827        69541       38.1
                                                   7560        31800       4.2
United Kingdom                                     513         18720       36.5
Australia                                          166         8413        50.7
India                                              870         3726        4.3
United Arab Emirates                               24          2959        123.3
Canada                                             192         2574        13.4
South Africa                                       84          1801        21.4
Sweden                                             59          1555        26.4
Slovenia                                           3           1535        511.7
Ireland                                            25          1222        48.9
Netherlands                                        91          855         9.4
Germany                                            41          647         15.8
Garden of Sakuntala                                1           563         563.0
Singapore                                          30          432         14.4
Norway                                             20          393         19.7
Brazil                                             51          391         7.7
New Zealand                                        36          387         10.8
Israel                                             31          280         9.0
Jordan                                             7           260         37.1
Philippines                                        57          208         3.6
Italy                                              38          202         5.3
Malaysia                                           60          200         3.3
Indonesia                                          46          178         3.9
Jamaica                                            4           177         44.3
Iran                                               23          156         6.8
Switzerland                                        12          146         12.2
Iraq                                               2           145         72.5
France                                             28          135         4.8
Turkey                                             32          126         3.9
Russia                                             25          107         4.3
Portugal                                           24          106         4.4
Mexico                                             36          103         2.9
Belgium                                            32          100         3.1
USSR                                               1           98          98.0
Pakistan                                           59          93          1.6
Kenya                                              5           93          18.6
Denmark                                            19          88          4.6
Spain                                              25          87          3.5
Vietnam                                            21          82          3.9
Greece                                             10          79          7.9
China                                              18          73          4.1
Latvia                                             2           73          36.5
Romania                                            25          65          2.6
Costa Rica                                         10          63          6.3
Bulgaria                                           4           61          15.3
Chile                                              9           52          5.8
Austria                                            12          49          4.1
Cuba                                               1           42          42.0
Moldova                                            3           40          13.3
Macao                                              1           39          39.0
Bosnia and Herzegovina                             2           34          17.0
Saudi Arabia                                       14          30          2.1
Bermuda                                            2           29          14.5
Republic of Korea                                  1           28          28.0
Colombia                                           7           26          3.7
Hungary                                            4           26          6.5
Nepal                                              3           25          8.3
Estonia                                            3           23          7.7
Venezuela                                          9           22          2.4
Finland                                            8           18          2.3
Yugoslavia                                         2           17          8.5
Poland                                             8           16          2.0
Wallis and Futuna Islands                          1           15          15.0
Argentina                                          9           14          1.6
Sri Lanka                                          7           13          1.9
Ukraine                                            7           13          1.9
Japan                                              6           13          2.2
Slovakia                                           1           13          13.0
Nigeria                                            8           12          1.5
Eritria                                            1           11          11.0
Egypt                                              20          9           .5
Peru                                               14          9           .6
Hong Kong                                          10          9           .9
Iceland                                            5           9           1.8
Belarus                                            2           9           4.5
Thailand                                           15          8           .5
Luxembourg                                         2           8           4.0
Taiwan                                             3           7           2.3
Andorra                                            2           6           3.0
Ecuador                                            2           5           2.5
Cambodia                                           2           5           2.5
Fed Rep Yugoslavia                                 1           5           5.0
NULL                                               169         4           .0
Czech Republic                                     7           4           .6
Morocco                                            3           4           1.3
Mauritius                                          2           4           2.0
Guatemala                                          4           3           .8
Bangladesh                                         4           3           .8
Lithuania                                          4           3           .8
Kuwait                                             3           3           1.0
Namibia                                            1           3           3.0
Croatia                                            4           2           .5
Zimbabwe (Rhodesia)                                3           2           .7
Kazakhstan                                         2           2           1.0
Seychelles                                         1           2           2.0
Trinidad and Tobago                                1           2           2.0
Bolivia                                            4           1           .3
Ghana                                              3           1           .3
Zambia                                             2           1           .5
Malta                                              2           1           .5
Mongolia                                           2           1           .5
Qatar                                              2           1           .5
Syria                                              2           1           .5
Georgia                                            1           1           1.0
Uruguay                                            1           1           1.0
Bahrain                                            1           1           1.0
Afghanistan                                        1           1           1.0
Albania                                            4           0           .0
Myanmar (Burma)                                    3           0           .0
Anguilla                                           3           0           .0
Uganda                                             3           0           .0
Korea                                              2           0           .0
Dominican Republic                                 2           0           .0
Barbados                                           2           0           .0
Tanzania                                           2           0           .0
Lebanon                                            1           0           .0
Armenia                                            1           0           .0
Fiji                                               1           0           .0
Sudan                                              1           0           .0
Papua New Guinea                                   1           0           .0
Fyro Macedonia                                     1           0           .0
Falkland Islands                                   1           0           .0
Oman                                               1           0           .0
Cyprus                                             1           0           .0
Algeria                                            1           0           .0

(126 row(s) affected)

M_COUNTRY                                          MEMBERS     TOTAL_POSTS POSTS_PER_MEMBER 
-------------------------------------------------- ----------- ----------- ---------------- 
Garden of Sakuntala                                1           563         563.0
Slovenia                                           3           1535        511.7
United Arab Emirates                               24          2959        123.3
USSR                                               1           98          98.0
Iraq                                               2           145         72.5
Australia                                          166         8413        50.7
Ireland                                            25          1222        48.9
Jamaica                                            4           177         44.3
Cuba                                               1           42          42.0
Macao                                              1           39          39.0
USA                                                1827        69541       38.1
Jordan                                             7           260         37.1
United Kingdom                                     513         18720       36.5
Latvia                                             2           73          36.5
Republic of Korea                                  1           28          28.0
Sweden                                             59          1555        26.4
South Africa                                       84          1801        21.4
Norway                                             20          393         19.7
Kenya                                              5           93          18.6
Bosnia and Herzegovina                             2           34          17.0
Germany                                            41          647         15.8
Bulgaria                                           4           61          15.3
Wallis and Futuna Islands                          1           15          15.0
Bermuda                                            2           29          14.5
Singapore                                          30          432         14.4
Canada                                             192         2574        13.4
Moldova                                            3           40          13.3
Slovakia                                           1           13          13.0
Switzerland                                        12          146         12.2
Eritria                                            1           11          11.0
New Zealand                                        36          387         10.8
Netherlands                                        91          855         9.4
Israel                                             31          280         9.0
Yugoslavia                                         2           17          8.5
Nepal                                              3           25          8.3
Greece                                             10          79          7.9
Brazil                                             51          391         7.7
Estonia                                            3           23          7.7
Iran                                               23          156         6.8
Hungary                                            4           26          6.5
Costa Rica                                         10          63          6.3
Chile                                              9           52          5.8
Italy                                              38          202         5.3
Fed Rep Yugoslavia                                 1           5           5.0
France                                             28          135         4.8
Denmark                                            19          88          4.6
Belarus                                            2           9           4.5
Portugal                                           24          106         4.4
India                                              870         3726        4.3
Russia                                             25          107         4.3
                                                   7560        31800       4.2
China                                              18          73          4.1
Austria                                            12          49          4.1
Luxembourg                                         2           8           4.0
Indonesia                                          46          178         3.9
Turkey                                             32          126         3.9
Vietnam                                            21          82          3.9
Colombia                                           7           26          3.7
Philippines                                        57          208         3.6
Spain                                              25          87          3.5
Malaysia                                           60          200         3.3
Belgium                                            32          100         3.1
Andorra                                            2           6           3.0
Namibia                                            1           3           3.0
Mexico                                             36          103         2.9
Romania                                            25          65          2.6
Ecuador                                            2           5           2.5
Cambodia                                           2           5           2.5
Venezuela                                          9           22          2.4
Finland                                            8           18          2.3
Taiwan                                             3           7           2.3
Japan                                              6           13          2.2
Saudi Arabia                                       14          30          2.1
Poland                                             8           16          2.0
Mauritius                                          2           4           2.0
Seychelles                                         1           2           2.0
Trinidad and Tobago                                1           2           2.0
Ukraine                                            7           13          1.9
Sri Lanka                                          7           13          1.9
Iceland                                            5           9           1.8
Pakistan                                           59          93          1.6
Argentina                                          9           14          1.6
Nigeria                                            8           12          1.5
Morocco                                            3           4           1.3
Kuwait                                             3           3           1.0
Kazakhstan                                         2           2           1.0
Uruguay                                            1           1           1.0
Georgia                                            1           1           1.0
Afghanistan                                        1           1           1.0
Bahrain                                            1           1           1.0
Hong Kong                                          10          9           .9
Lithuania                                          4           3           .8
Bangladesh                                         4           3           .8
Guatemala                                          4           3           .8
Zimbabwe (Rhodesia)                                3           2           .7
Peru                                               14          9           .6
Czech Republic                                     7           4           .6
Egypt                                              20          9           .5
Thailand                                           15          8           .5
Croatia                                            4           2           .5
Zambia                                             2           1           .5
Malta                                              2           1           .5
Mongolia                                           2           1           .5
Syria                                              2           1           .5
Qatar                                              2           1           .5
Bolivia                                            4           1           .3
Ghana                                              3           1           .3
NULL                                               169         4           .0
Albania                                            4           0           .0
Myanmar (Burma)                                    3           0           .0
Anguilla                                           3           0           .0
Uganda                                             3           0           .0
Korea                                              2           0           .0
Dominican Republic                                 2           0           .0
Barbados                                           2           0           .0
Tanzania                                           2           0           .0
Lebanon                                            1           0           .0
Fiji                                               1           0           .0
Armenia                                            1           0           .0
Cyprus                                             1           0           .0
Falkland Islands                                   1           0           .0
Oman                                               1           0           .0
Sudan                                              1           0           .0
Papua New Guinea                                   1           0           .0
Fyro Macedonia                                     1           0           .0
Algeria                                            1           0           .0

(126 row(s) affected)



===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.
Go to Top of Page

Seventhnight
Master Smack Fu Yak Hacker

2878 Posts
Posted - 2004-10-07 : 20:29:27
quote:
USA                                                1827        69541       38.1

thats really a pretty decent average...

quote:

Garden of Sakuntala                                1           563         563.0
Slovenia                                           3           1535        511.7

Thats hardly fair


Corey
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts
Posted - 2004-10-08 : 04:46:43
yeah!!!
Slovenia and Garden of Sakuntala ROCKS!!

Go with the flow & have fun! Else fight the flow
Go to Top of Page
    Next Page

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site