-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathGenerate Websites Database.sql
6340 lines (6294 loc) · 1.38 MB
/
Generate Websites Database.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
/*
All code and data belongs to Wise Owl, and must not be reproduced or distributed
in any way without prior written permission
Note that this code is not written as a training aid, but instead is just
a means to create a SQL Server database on the user's computer
Code assumes Websites database does not already exist
*/
USE Master
go
-- drop database if exists
BEGIN TRY
DROP DATABASE Websites
END TRY
BEGIN CATCH
-- database can't exist
END CATCH
-- create new database
CREATE DATABASE Websites
go
USE Websites
GO
CREATE TABLE [dbo].[tblDomain](
[DomainId] [int] IDENTITY(1,1) NOT NULL,
[DomainName] [varchar](100) NULL,
CONSTRAINT [tblDomainPrimaryKey] PRIMARY KEY CLUSTERED
(
[DomainId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[tblDomain] ON
INSERT [dbo].[tblDomain] ([DomainId], [DomainName]) VALUES (1, N'.au')
INSERT [dbo].[tblDomain] ([DomainId], [DomainName]) VALUES (2, N'.br')
INSERT [dbo].[tblDomain] ([DomainId], [DomainName]) VALUES (3, N'.ca')
INSERT [dbo].[tblDomain] ([DomainId], [DomainName]) VALUES (4, N'.cn')
INSERT [dbo].[tblDomain] ([DomainId], [DomainName]) VALUES (5, N'.com')
INSERT [dbo].[tblDomain] ([DomainId], [DomainName]) VALUES (6, N'.de')
INSERT [dbo].[tblDomain] ([DomainId], [DomainName]) VALUES (7, N'.es')
INSERT [dbo].[tblDomain] ([DomainId], [DomainName]) VALUES (8, N'.fr')
INSERT [dbo].[tblDomain] ([DomainId], [DomainName]) VALUES (9, N'.id')
INSERT [dbo].[tblDomain] ([DomainId], [DomainName]) VALUES (10, N'.in')
INSERT [dbo].[tblDomain] ([DomainId], [DomainName]) VALUES (11, N'.it')
INSERT [dbo].[tblDomain] ([DomainId], [DomainName]) VALUES (12, N'.jp')
INSERT [dbo].[tblDomain] ([DomainId], [DomainName]) VALUES (13, N'.net')
INSERT [dbo].[tblDomain] ([DomainId], [DomainName]) VALUES (14, N'.org')
INSERT [dbo].[tblDomain] ([DomainId], [DomainName]) VALUES (15, N'.pl')
INSERT [dbo].[tblDomain] ([DomainId], [DomainName]) VALUES (16, N'.ru')
INSERT [dbo].[tblDomain] ([DomainId], [DomainName]) VALUES (17, N'.tr')
INSERT [dbo].[tblDomain] ([DomainId], [DomainName]) VALUES (18, N'.uk')
INSERT [dbo].[tblDomain] ([DomainId], [DomainName]) VALUES (19, N'.us')
SET IDENTITY_INSERT [dbo].[tblDomain] OFF
/****** Object: Table [dbo].[tblCountry] Script Date: 02/05/2010 16:00:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tblCountry](
[CountryId] [int] IDENTITY(1,1) NOT NULL,
[CountryName] [varchar](100) NULL,
CONSTRAINT [tblCountryPrimaryKey] PRIMARY KEY CLUSTERED
(
[CountryId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[tblCountry] ON
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (1, N'Puerto Rico')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (2, N'Finland')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (3, N'Vietnam')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (4, N'Brazil')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (5, N'Cameroon')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (6, N'Belarus')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (7, N'Hong Kong')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (8, N'Malaysia')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (9, N'South Korea')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (10, N'Guatemala')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (11, N'Angola')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (12, N'Egypt')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (13, N'Italy')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (14, N'Azerbaijan')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (15, N'Netherlands')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (16, N'Gibraltar')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (17, N'Germany')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (18, N'Philippines')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (19, N'Uzbekistan')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (20, N'United States')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (21, N'Algeria')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (22, N'Nigeria')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (23, N'Saudi Arabia')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (24, N'Iraq')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (25, N'Australia')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (26, N'Mexico')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (27, N'Honduras')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (28, N'Syrian Arab Republic')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (29, N'Argentina')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (30, N'Indonesia')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (31, N'Kuwait')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (32, N'Hungary')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (33, N'Switzerland')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (34, N'Ecuador')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (35, N'El Salvador')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (36, N'United Kingdom')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (37, N'Sweden')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (38, N'Nicaragua')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (39, N'Kenya')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (40, N'Ukraine')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (41, N'China')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (42, N'Armenia')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (43, N'Austria')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (44, N'Qatar')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (45, N'Poland')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (46, N'Canada')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (47, N'Sudan')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (48, N'Libyan Arab Jamahiriya')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (49, N'Ireland')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (50, N'Thailand')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (51, N'France')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (52, N'Peru')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (53, N'India')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (54, N'Cote d''Ivoire')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (55, N'Greece')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (56, N'United Arab Emirates')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (57, N'Russia')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (58, N'Israel')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (59, N'Tunisia')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (60, N'Moldova')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (61, N'Norway')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (62, N'Morocco')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (63, N'Turkey')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (64, N'Venezuela')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (65, N'Bangladesh')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (66, N'Singapore')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (67, N'Chile')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (68, N'Taiwan')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (69, N'Kazakhstan')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (70, N'Costa Rica')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (71, N'Paraguay')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (72, N'Dominican Republic')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (73, N'Belgium')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (74, N'Japan')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (75, N'Georgia')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (76, N'Spain')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (77, N'Oman')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (78, N'OTHER')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (79, N'Pakistan')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (80, N'Romania')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (81, N'Denmark')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (82, N'Colombia')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (83, N'Iran')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (84, N'South Africa')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (85, N'Czech Republic')
INSERT [dbo].[tblCountry] ([CountryId], [CountryName]) VALUES (86, N'Portugal')
SET IDENTITY_INSERT [dbo].[tblCountry] OFF
/****** Object: Table [dbo].[tblCompany] Script Date: 02/05/2010 16:00:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tblCompany](
[CompanyId] [int] IDENTITY(1,1) NOT NULL,
[CompanyName] [varchar](100) NULL,
CONSTRAINT [tblCompanyPrimaryKey] PRIMARY KEY CLUSTERED
(
[CompanyId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[tblCompany] ON
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (1, N'163.com')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (2, N'1e100.net')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (3, N'4 Shared')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (4, N'About.com')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (5, N'Adobe')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (6, N'Adult site company 1')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (7, N'Adult site company 2')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (8, N'Adult site company 3')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (9, N'Adult site company 4')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (10, N'Adult site company 5')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (11, N'Adult site company 6')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (12, N'Adult site company 7')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (13, N'Amazon')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (14, N'Ameblo')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (15, N'AOL')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (16, N'Apple')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (17, N'Argos')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (18, N'Ask.com')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (19, N'Baidu')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (20, N'Barclays Bank')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (21, N'BBC')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (22, N'Blogger')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (23, N'Blogspot')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (24, N'BSkyB')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (25, N'Camelot')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (26, N'CNET')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (27, N'CNN')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (28, N'Conduit')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (29, N'Craig List')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (30, N'Daily Mail')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (31, N'Daily Motion')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (32, N'Daily Telegraph')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (33, N'Digg')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (34, N'Double-click')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (35, N'Ebay')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (36, N'ESPN')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (37, N'Facebook')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (38, N'FC2')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (39, N'Flickr')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (40, N'Go')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (41, N'Google')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (42, N'Guardian')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (43, N'Gumtree')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (44, N'Hi5')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (45, N'HotFile.com')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (46, N'HSBC')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (47, N'Image Shack')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (48, N'Internet Movie Database')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (49, N'Kaixin001')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (50, N'Linked In')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (51, N'Live Journal')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (52, N'LiveDoor')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (53, N'Mail.ru')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (54, N'MediaFire')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (55, N'Mega Upload')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (56, N'MegaVideo')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (57, N'Met Office')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (58, N'Microsoft')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (59, N'Mixi')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (60, N'Mozilla')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (61, N'MySpace')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (62, N'New York Times')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (63, N'News International')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (64, N'None')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (65, N'Odnokassniki.ru')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (66, N'Orkut')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (67, N'Party Poker')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (68, N'PayPal')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (69, N'PhotoBucket')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (70, N'Play.com')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (71, N'QQ')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (72, N'Rakuten')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (73, N'RapidShare')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (74, N'renren.com')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (75, N'Sina.com')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (76, N'Sohu')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (77, N'Soso')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (78, N'TaoBao')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (79, N'Tesco')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (80, N'The Pirate Bay')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (81, N'Tianya')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (82, N'Tudou')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (83, N'Twitter')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (84, N'Universo')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (85, N'V Kontakte')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (86, N'Virgin Media')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (87, N'Weather.com')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (88, N'Wise Owl Business Solutions')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (89, N'WordPress')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (90, N'Yahoo')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (91, N'Yandex')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (92, N'YouKu')
INSERT [dbo].[tblCompany] ([CompanyId], [CompanyName]) VALUES (93, N'YouTube')
SET IDENTITY_INSERT [dbo].[tblCompany] OFF
/****** Object: Table [dbo].[tblCategory] Script Date: 02/05/2010 16:00:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tblCategory](
[CategoryId] [int] IDENTITY(1,1) NOT NULL,
[CategoryName] [varchar](100) NULL,
CONSTRAINT [tblCategoryPrimaryKey] PRIMARY KEY CLUSTERED
(
[CategoryId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[tblCategory] ON
INSERT [dbo].[tblCategory] ([CategoryId], [CategoryName]) VALUES (1, N'Adult')
INSERT [dbo].[tblCategory] ([CategoryId], [CategoryName]) VALUES (2, N'Betting')
INSERT [dbo].[tblCategory] ([CategoryId], [CategoryName]) VALUES (3, N'Blogs')
INSERT [dbo].[tblCategory] ([CategoryId], [CategoryName]) VALUES (4, N'Business networking')
INSERT [dbo].[tblCategory] ([CategoryId], [CategoryName]) VALUES (5, N'Classifieds')
INSERT [dbo].[tblCategory] ([CategoryId], [CategoryName]) VALUES (6, N'Company specific')
INSERT [dbo].[tblCategory] ([CategoryId], [CategoryName]) VALUES (7, N'File sharing')
INSERT [dbo].[tblCategory] ([CategoryId], [CategoryName]) VALUES (8, N'Finance')
INSERT [dbo].[tblCategory] ([CategoryId], [CategoryName]) VALUES (9, N'Internet marketing')
INSERT [dbo].[tblCategory] ([CategoryId], [CategoryName]) VALUES (10, N'Knowledge portal')
INSERT [dbo].[tblCategory] ([CategoryId], [CategoryName]) VALUES (11, N'Mail')
INSERT [dbo].[tblCategory] ([CategoryId], [CategoryName]) VALUES (12, N'Messenging')
INSERT [dbo].[tblCategory] ([CategoryId], [CategoryName]) VALUES (13, N'Music')
INSERT [dbo].[tblCategory] ([CategoryId], [CategoryName]) VALUES (14, N'News portal')
INSERT [dbo].[tblCategory] ([CategoryId], [CategoryName]) VALUES (15, N'Not known')
INSERT [dbo].[tblCategory] ([CategoryId], [CategoryName]) VALUES (16, N'Photos and videos')
INSERT [dbo].[tblCategory] ([CategoryId], [CategoryName]) VALUES (17, N'Portal')
INSERT [dbo].[tblCategory] ([CategoryId], [CategoryName]) VALUES (18, N'Search engine')
INSERT [dbo].[tblCategory] ([CategoryId], [CategoryName]) VALUES (19, N'Shopping/auction')
INSERT [dbo].[tblCategory] ([CategoryId], [CategoryName]) VALUES (20, N'Social networking')
INSERT [dbo].[tblCategory] ([CategoryId], [CategoryName]) VALUES (21, N'Software company/tools')
INSERT [dbo].[tblCategory] ([CategoryId], [CategoryName]) VALUES (22, N'Specialist')
INSERT [dbo].[tblCategory] ([CategoryId], [CategoryName]) VALUES (23, N'Sports')
INSERT [dbo].[tblCategory] ([CategoryId], [CategoryName]) VALUES (24, N'Weather')
SET IDENTITY_INSERT [dbo].[tblCategory] OFF
/****** Object: Table [dbo].[Rankings] Script Date: 02/05/2010 16:00:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Rankings](
[Id] [int] IDENTITY(1,1) NOT NULL,
[RankingId] [float] NULL,
[Proportion] [float] NULL,
[Country] [nvarchar](255) NULL,
[upsize_ts] [timestamp] NULL,
CONSTRAINT [aaaaaRankings_PK] PRIMARY KEY NONCLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'18' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'Rankings_local' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'RankingId'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'RankingId'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'RankingId'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'RankingId'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'RankingId'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'RankingId'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'RankingId'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'RankingId'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'RankingId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DecimalPlaces', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'RankingId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'RankingId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Format', @value=N'General Number' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'RankingId'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'RankingId' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'RankingId'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'RankingId'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'RankingId'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'8' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'RankingId'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'RankingId' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'RankingId'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'Rankings_local' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'RankingId'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'RankingId'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'7' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'RankingId'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Proportion'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Proportion'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Proportion'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Proportion'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Proportion'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Proportion'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Proportion'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Proportion'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Proportion'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DecimalPlaces', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Proportion'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Proportion'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Format', @value=N'General Number' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Proportion'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'Proportion' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Proportion'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Proportion'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Proportion'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'8' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Proportion'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'Proportion' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Proportion'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'Rankings_local' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Proportion'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Proportion'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'7' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Proportion'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Country'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Country'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Country'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Country'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Country'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Country'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Country'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Country'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Country'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Country'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Format', @value=N'@' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Country'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Country'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Country'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'Country' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Country'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Country'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Country'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Country'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'Country' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Country'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'Rankings_local' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Country'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Country'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Country'
GO
EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings', @level2type=N'COLUMN',@level2name=N'Country'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings'
GO
EXEC sys.sp_addextendedproperty @name=N'DateCreated', @value=N'15/01/2010 13:38:30' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings'
GO
EXEC sys.sp_addextendedproperty @name=N'DisplayViewsOnSharePointSite', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings'
GO
EXEC sys.sp_addextendedproperty @name=N'FilterOnLoad', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings'
GO
EXEC sys.sp_addextendedproperty @name=N'HideNewField', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings'
GO
EXEC sys.sp_addextendedproperty @name=N'LastUpdated', @value=N'15/01/2010 13:47:35' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DefaultView', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_OrderByOn', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Orientation', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'Rankings_local' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings'
GO
EXEC sys.sp_addextendedproperty @name=N'OrderByOnLoad', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings'
GO
EXEC sys.sp_addextendedproperty @name=N'RecordCount', @value=N'2276' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings'
GO
EXEC sys.sp_addextendedproperty @name=N'TotalsRow', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings'
GO
EXEC sys.sp_addextendedproperty @name=N'Updatable', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rankings'
GO
SET IDENTITY_INSERT [dbo].[Rankings] ON
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (1, 1, 0.005, N'Bangladesh')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (2, 1, 0.005, N'Egypt')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (3, 1, 0.005, N'Sweden')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (4, 1, 0.005, N'Thailand')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (5, 1, 0.006, N'Algeria')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (6, 1, 0.006, N'Poland')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (7, 1, 0.008, N'Saudi Arabia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (8, 1, 0.009, N'Netherlands')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (9, 1, 0.009, N'South Africa')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (10, 1, 0.01, N'Mexico')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (11, 1, 0.011, N'Pakistan')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (12, 1, 0.012, N'Australia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (13, 1, 0.012, N'Turkey')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (14, 1, 0.014, N'Russia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (15, 1, 0.015, N'France')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (16, 1, 0.015, N'Spain')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (17, 1, 0.016, N'Indonesia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (18, 1, 0.017, N'Canada')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (19, 1, 0.019, N'Italy')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (20, 1, 0.15, N'OTHER')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (21, 1, 0.021, N'Japan')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (22, 1, 0.028, N'Iran')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (23, 1, 0.03, N'United Kingdom')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (24, 1, 0.033, N'Germany')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (25, 1, 0.035, N'Brazil')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (26, 1, 0.35, N'United States')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (27, 1, 0.064, N'China')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (28, 1, 0.088, N'India')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (29, 2, 0.005, N'Czech Republic')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (30, 2, 0.005, N'Norway')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (31, 2, 0.006, N'Japan')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (32, 2, 0.006, N'Saudi Arabia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (33, 2, 0.006, N'Singapore')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (34, 2, 0.006, N'Switzerland')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (35, 2, 0.007, N'Austria')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (36, 2, 0.007, N'Bangladesh')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (37, 2, 0.007, N'Thailand')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (38, 2, 0.008, N'Chile')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (39, 2, 0.008, N'Hong Kong')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (40, 2, 0.008, N'Sweden')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (41, 2, 0.009, N'Belgium')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (42, 2, 0.009, N'Egypt')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (43, 2, 0.009, N'Greece')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (44, 2, 0.01, N'Colombia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (45, 2, 0.011, N'Malaysia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (46, 2, 0.011, N'Venezuela')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (47, 2, 0.012, N'Pakistan')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (48, 2, 0.012, N'Philippines')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (49, 2, 0.012, N'South Africa')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (50, 2, 0.012, N'Taiwan')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (51, 2, 0.014, N'Argentina')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (52, 2, 0.017, N'Australia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (53, 2, 0.136, N'OTHER')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (54, 2, 0.021, N'Mexico')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (55, 2, 0.022, N'Spain')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (56, 2, 0.023, N'Turkey')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (57, 2, 0.029, N'Canada')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (58, 2, 0.297, N'United States')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (59, 2, 0.032, N'Germany')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (60, 2, 0.034, N'Indonesia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (61, 2, 0.042, N'India')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (62, 2, 0.048, N'Italy')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (63, 2, 0.048, N'United Kingdom')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (64, 2, 0.051, N'France')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (65, 3, 0.005, N'Singapore')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (66, 3, 0.006, N'Algeria')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (67, 3, 0.006, N'Austria')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (68, 3, 0.006, N'Chile')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (69, 3, 0.006, N'Hong Kong')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (70, 3, 0.006, N'Portugal')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (71, 3, 0.006, N'South Korea')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (72, 3, 0.006, N'Switzerland')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (73, 3, 0.007, N'Belgium')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (74, 3, 0.007, N'Malaysia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (75, 3, 0.007, N'Peru')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (76, 3, 0.007, N'Romania')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (77, 3, 0.007, N'Sweden')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (78, 3, 0.007, N'Taiwan')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (79, 3, 0.007, N'Venezuela')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (80, 3, 0.008, N'Colombia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (81, 3, 0.008, N'Philippines')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (82, 3, 0.009, N'Egypt')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (83, 3, 0.009, N'Greece')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (84, 3, 0.009, N'Thailand')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (85, 3, 0.01, N'Turkey')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (86, 3, 0.011, N'Argentina')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (87, 3, 0.011, N'Indonesia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (88, 3, 0.012, N'Pakistan')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (89, 3, 0.013, N'Australia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (90, 3, 0.013, N'Netherlands')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (91, 3, 0.015, N'Poland')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (92, 3, 0.015, N'Saudi Arabia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (93, 3, 0.018, N'Russia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (94, 3, 0.117, N'OTHER')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (95, 3, 0.024, N'Canada')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (96, 3, 0.026, N'Spain')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (97, 3, 0.233, N'United States')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (98, 3, 0.034, N'France')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (99, 3, 0.037, N'Brazil')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (100, 3, 0.037, N'Mexico')
GO
print 'Processed 100 total records'
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (101, 3, 0.038, N'United Kingdom')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (102, 3, 0.039, N'Italy')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (103, 3, 0.042, N'India')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (104, 3, 0.048, N'Germany')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (105, 3, 0.069, N'Japan')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (106, 4, 0.005, N'Saudi Arabia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (107, 4, 0.005, N'South Africa')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (108, 4, 0.006, N'Bangladesh')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (109, 4, 0.006, N'Russia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (110, 4, 0.006, N'Singapore')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (111, 4, 0.007, N'Argentina')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (112, 4, 0.007, N'Nigeria')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (113, 4, 0.007, N'Vietnam')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (114, 4, 0.008, N'Romania')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (115, 4, 0.009, N'Japan')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (116, 4, 0.01, N'South Korea')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (117, 4, 0.011, N'Australia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (118, 4, 0.011, N'Egypt')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (119, 4, 0.011, N'Malaysia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (120, 4, 0.012, N'Pakistan')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (121, 4, 0.012, N'Philippines')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (122, 4, 0.013, N'Spain')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (123, 4, 0.014, N'Hong Kong')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (124, 4, 0.017, N'Mexico')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (125, 4, 0.018, N'France')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (126, 4, 0.127, N'OTHER')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (127, 4, 0.021, N'Canada')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (128, 4, 0.022, N'Brazil')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (129, 4, 0.023, N'Germany')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (130, 4, 0.023, N'Italy')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (131, 4, 0.026, N'Iran')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (132, 4, 0.027, N'Indonesia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (133, 4, 0.033, N'United Kingdom')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (134, 4, 0.035, N'Taiwan')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (135, 4, 0.037, N'China')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (136, 4, 0.341, N'United States')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (137, 4, 0.088, N'India')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (138, 5, 0.005, N'Ecuador')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (139, 5, 0.006, N'Greece')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (140, 5, 0.006, N'Hong Kong')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (141, 5, 0.006, N'Malaysia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (142, 5, 0.006, N'Singapore')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (143, 5, 0.006, N'Switzerland')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (144, 5, 0.008, N'Egypt')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (145, 5, 0.008, N'Sweden')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (146, 5, 0.008, N'Taiwan')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (147, 5, 0.009, N'Algeria')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (148, 5, 0.009, N'Portugal')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (149, 5, 0.01, N'Chile')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (150, 5, 0.013, N'Belgium')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (151, 5, 0.013, N'Peru')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (152, 5, 0.014, N'Pakistan')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (153, 5, 0.015, N'Australia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (154, 5, 0.015, N'Venezuela')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (155, 5, 0.016, N'Germany')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (156, 5, 0.017, N'Colombia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (157, 5, 0.019, N'Netherlands')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (158, 5, 0.126, N'OTHER')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (159, 5, 0.14, N'United States')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (160, 5, 0.02, N'Thailand')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (161, 5, 0.021, N'India')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (162, 5, 0.021, N'Japan')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (163, 5, 0.024, N'Saudi Arabia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (164, 5, 0.024, N'Turkey')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (165, 5, 0.025, N'Argentina')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (166, 5, 0.031, N'Italy')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (167, 5, 0.035, N'Canada')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (168, 5, 0.045, N'Spain')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (169, 5, 0.046, N'China')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (170, 5, 0.046, N'United Kingdom')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (171, 5, 0.06, N'France')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (172, 5, 0.062, N'Brazil')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (173, 5, 0.064, N'Mexico')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (174, 6, 0.005, N'Belgium')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (175, 6, 0.005, N'Greece')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (176, 6, 0.005, N'Malaysia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (177, 6, 0.005, N'South Korea')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (178, 6, 0.006, N'Argentina')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (179, 6, 0.006, N'Philippines')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (180, 6, 0.006, N'Switzerland')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (181, 6, 0.006, N'Thailand')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (182, 6, 0.007, N'Ukraine')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (183, 6, 0.008, N'South Africa')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (184, 6, 0.008, N'Sweden')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (185, 6, 0.009, N'Austria')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (186, 6, 0.009, N'Pakistan')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (187, 6, 0.01, N'Turkey')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (188, 6, 0.011, N'Indonesia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (189, 6, 0.012, N'Iran')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (190, 6, 0.012, N'Netherlands')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (191, 6, 0.015, N'Australia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (192, 6, 0.015, N'Poland')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (193, 6, 0.017, N'Brazil')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (194, 6, 0.019, N'Spain')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (195, 6, 0.141, N'OTHER')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (196, 6, 0.022, N'Canada')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (197, 6, 0.022, N'Mexico')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (198, 6, 0.024, N'China')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (199, 6, 0.026, N'France')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (200, 6, 0.234, N'United States')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (201, 6, 0.035, N'Italy')
GO
print 'Processed 200 total records'
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (202, 6, 0.036, N'Russia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (203, 6, 0.044, N'United Kingdom')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (204, 6, 0.059, N'India')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (205, 6, 0.077, N'Germany')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (206, 6, 0.084, N'Japan')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (207, 7, 0.006, N'Bangladesh')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (208, 7, 0.006, N'Chile')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (209, 7, 0.006, N'China')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (210, 7, 0.006, N'Poland')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (211, 7, 0.006, N'South Korea')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (212, 7, 0.006, N'Taiwan')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (213, 7, 0.007, N'Colombia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (214, 7, 0.007, N'Netherlands')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (215, 7, 0.007, N'Peru')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (216, 7, 0.007, N'Philippines')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (217, 7, 0.007, N'Romania')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (218, 7, 0.007, N'Saudi Arabia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (219, 7, 0.007, N'South Africa')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (220, 7, 0.007, N'Sweden')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (221, 7, 0.008, N'Singapore')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (222, 7, 0.009, N'Egypt')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (223, 7, 0.009, N'Portugal')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (224, 7, 0.009, N'Venezuela')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (225, 7, 0.011, N'Thailand')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (226, 7, 0.012, N'Russia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (227, 7, 0.013, N'Australia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (228, 7, 0.013, N'Greece')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (229, 7, 0.014, N'Argentina')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (230, 7, 0.014, N'Malaysia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (231, 7, 0.015, N'Pakistan')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (232, 7, 0.017, N'Canada')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (233, 7, 0.017, N'France')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (234, 7, 0.017, N'Iran')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (235, 7, 0.017, N'Turkey')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (236, 7, 0.1, N'India')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (237, 7, 0.105, N'OTHER')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (238, 7, 0.028, N'Japan')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (239, 7, 0.216, N'United States')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (240, 7, 0.031, N'United Kingdom')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (241, 7, 0.032, N'Germany')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (242, 7, 0.033, N'Spain')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (243, 7, 0.034, N'Italy')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (244, 7, 0.034, N'Mexico')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (245, 7, 0.05, N'Indonesia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (246, 7, 0.052, N'Brazil')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (247, 8, 0.006, N'United States')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (248, 8, 0.029, N'OTHER')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (249, 8, 0.964, N'China')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (250, 9, 0.006, N'Malaysia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (251, 9, 0.006, N'Singapore')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (252, 9, 0.006, N'Taiwan')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (253, 9, 0.007, N'Chile')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (254, 9, 0.007, N'Portugal')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (255, 9, 0.007, N'Sweden')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (256, 9, 0.008, N'Algeria')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (257, 9, 0.01, N'Belgium')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (258, 9, 0.01, N'Egypt')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (259, 9, 0.01, N'Peru')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (260, 9, 0.01, N'Russia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (261, 9, 0.012, N'Iran')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (262, 9, 0.012, N'Pakistan')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (263, 9, 0.012, N'Venezuela')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (264, 9, 0.013, N'Turkey')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (265, 9, 0.014, N'Netherlands')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (266, 9, 0.015, N'Colombia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (267, 9, 0.016, N'Saudi Arabia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (268, 9, 0.016, N'Thailand')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (269, 9, 0.017, N'Germany')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (270, 9, 0.018, N'Argentina')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (271, 9, 0.147, N'OTHER')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (272, 9, 0.024, N'Italy')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (273, 9, 0.029, N'India')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (274, 9, 0.029, N'Spain')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (275, 9, 0.206, N'United States')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (276, 9, 0.033, N'Canada')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (277, 9, 0.036, N'China')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (278, 9, 0.037, N'United Kingdom')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (279, 9, 0.048, N'France')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (280, 9, 0.055, N'Japan')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (281, 9, 0.059, N'Mexico')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (282, 9, 0.066, N'Brazil')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (283, 10, 0.009, N'China')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (284, 10, 0.017, N'OTHER')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (285, 10, 0.974, N'Japan')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (286, 11, 0.005, N'United States')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (287, 11, 0.02, N'OTHER')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (288, 11, 0.975, N'China')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (289, 12, 0.005, N'Saudi Arabia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (290, 12, 0.006, N'Austria')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (291, 12, 0.006, N'Philippines')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (292, 12, 0.006, N'South Korea')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (293, 12, 0.007, N'Sweden')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (294, 12, 0.007, N'Thailand')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (295, 12, 0.008, N'China')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (296, 12, 0.011, N'France')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (297, 12, 0.011, N'Mexico')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (298, 12, 0.011, N'Russia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (299, 12, 0.012, N'Turkey')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (300, 12, 0.013, N'South Africa')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (301, 12, 0.014, N'Pakistan')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (302, 12, 0.014, N'Spain')
GO
print 'Processed 300 total records'
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (303, 12, 0.015, N'Italy')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (304, 12, 0.016, N'Netherlands')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (305, 12, 0.117, N'OTHER')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (306, 12, 0.02, N'Australia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (307, 12, 0.021, N'Indonesia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (308, 12, 0.025, N'Canada')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (309, 12, 0.028, N'Brazil')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (310, 12, 0.368, N'United States')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (311, 12, 0.047, N'Japan')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (312, 12, 0.059, N'United Kingdom')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (313, 12, 0.068, N'Germany')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (314, 12, 0.083, N'India')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (315, 13, 0.008, N'United States')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (316, 13, 0.023, N'OTHER')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (317, 13, 0.97, N'India')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (318, 14, 0.005, N'China')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (319, 14, 0.005, N'Indonesia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (320, 14, 0.005, N'Netherlands')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (321, 14, 0.006, N'Austria')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (322, 14, 0.006, N'Greece')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (323, 14, 0.006, N'Poland')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (324, 14, 0.006, N'Turkey')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (325, 14, 0.007, N'Brazil')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (326, 14, 0.008, N'Puerto Rico')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (327, 14, 0.009, N'Russia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (328, 14, 0.01, N'Malaysia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (329, 14, 0.012, N'Spain')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (330, 14, 0.013, N'Canada')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (331, 14, 0.015, N'Australia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (332, 14, 0.015, N'Japan')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (333, 14, 0.019, N'France')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (334, 14, 0.019, N'India')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (335, 14, 0.02, N'Italy')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (336, 14, 0.029, N'United Kingdom')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (337, 14, 0.036, N'Mexico')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (338, 14, 0.049, N'Germany')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (339, 14, 0.604, N'United States')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (340, 14, 0.098, N'OTHER')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (341, 15, 0.02, N'OTHER')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (342, 15, 0.98, N'China')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (343, 16, 0.005, N'Japan')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (344, 16, 0.011, N'United States')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (345, 16, 0.026, N'OTHER')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (346, 16, 0.958, N'China')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (347, 17, 0.006, N'France')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (348, 17, 0.006, N'Switzerland')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (349, 17, 0.017, N'Austria')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (350, 17, 0.05, N'OTHER')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (351, 17, 0.921, N'Germany')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (352, 18, 0.005, N'Brazil')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (353, 18, 0.006, N'Russia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (354, 18, 0.006, N'Spain')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (355, 18, 0.006, N'Venezuela')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (356, 18, 0.007, N'Italy')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (357, 18, 0.007, N'Mexico')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (358, 18, 0.007, N'Pakistan')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (359, 18, 0.008, N'Japan')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (360, 18, 0.009, N'South Africa')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (361, 18, 0.009, N'Thailand')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (362, 18, 0.011, N'Indonesia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (363, 18, 0.015, N'Australia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (364, 18, 0.119, N'OTHER')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (365, 18, 0.02, N'Germany')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (366, 18, 0.021, N'China')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (367, 18, 0.022, N'Canada')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (368, 18, 0.03, N'United Kingdom')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (369, 18, 0.036, N'India')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (370, 18, 0.658, N'United States')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (371, 19, 0.005, N'Austria')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (372, 19, 0.005, N'Colombia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (373, 19, 0.005, N'Singapore')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (374, 19, 0.006, N'Peru')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (375, 19, 0.006, N'Portugal')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (376, 19, 0.006, N'Saudi Arabia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (377, 19, 0.006, N'South Korea')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (378, 19, 0.007, N'Philippines')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (379, 19, 0.007, N'Poland')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (380, 19, 0.007, N'Venezuela')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (381, 19, 0.008, N'Russia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (382, 19, 0.009, N'Argentina')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (383, 19, 0.009, N'Greece')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (384, 19, 0.009, N'Malaysia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (385, 19, 0.009, N'South Africa')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (386, 19, 0.009, N'Sweden')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (387, 19, 0.009, N'Thailand')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (388, 19, 0.01, N'Netherlands')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (389, 19, 0.01, N'Romania')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (390, 19, 0.011, N'Japan')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (391, 19, 0.013, N'China')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (392, 19, 0.014, N'Australia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (393, 19, 0.014, N'Turkey')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (394, 19, 0.015, N'France')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (395, 19, 0.016, N'Pakistan')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (396, 19, 0.112, N'OTHER')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (397, 19, 0.02, N'Canada')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (398, 19, 0.029, N'Mexico')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (399, 19, 0.24, N'United States')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (400, 19, 0.03, N'Iran')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (401, 19, 0.03, N'Spain')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (402, 19, 0.036, N'Italy')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (403, 19, 0.038, N'United Kingdom')
GO
print 'Processed 400 total records'
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (404, 19, 0.039, N'Brazil')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (405, 19, 0.047, N'Germany')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (406, 19, 0.067, N'Indonesia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (407, 19, 0.087, N'India')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (408, 20, 0.005, N'Austria')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (409, 20, 0.005, N'Peru')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (410, 20, 0.005, N'Venezuela')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (411, 20, 0.006, N'Belgium')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (412, 20, 0.006, N'Colombia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (413, 20, 0.006, N'Greece')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (414, 20, 0.006, N'Portugal')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (415, 20, 0.006, N'Sweden')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (416, 20, 0.007, N'Argentina')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (417, 20, 0.007, N'Poland')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (418, 20, 0.007, N'Taiwan')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (419, 20, 0.008, N'South Africa')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (420, 20, 0.008, N'South Korea')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (421, 20, 0.009, N'Algeria')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (422, 20, 0.011, N'Australia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (423, 20, 0.011, N'Indonesia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (424, 20, 0.011, N'Netherlands')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (425, 20, 0.011, N'Pakistan')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (426, 20, 0.014, N'Egypt')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (427, 20, 0.015, N'Saudi Arabia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (428, 20, 0.015, N'Thailand')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (429, 20, 0.018, N'Spain')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (430, 20, 0.018, N'Turkey')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (431, 20, 0.144, N'OTHER')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (432, 20, 0.02, N'Canada')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (433, 20, 0.023, N'France')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (434, 20, 0.024, N'Iran')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (435, 20, 0.024, N'Mexico')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (436, 20, 0.025, N'Italy')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (437, 20, 0.029, N'Russia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (438, 20, 0.202, N'United States')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (439, 20, 0.031, N'Brazil')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (440, 20, 0.031, N'United Kingdom')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (441, 20, 0.036, N'Germany')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (442, 20, 0.048, N'Japan')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (443, 20, 0.073, N'India')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (444, 20, 0.074, N'China')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (445, 21, 0.005, N'South Korea')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (446, 21, 0.005, N'Thailand')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (447, 21, 0.006, N'France')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (448, 21, 0.006, N'Greece')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (449, 21, 0.006, N'Japan')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (450, 21, 0.006, N'Spain')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (451, 21, 0.007, N'Indonesia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (452, 21, 0.008, N'Italy')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (453, 21, 0.008, N'Mexico')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (454, 21, 0.011, N'Russia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (455, 21, 0.013, N'Australia')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (456, 21, 0.015, N'Germany')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (457, 21, 0.116, N'OTHER')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (458, 21, 0.02, N'China')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (459, 21, 0.02, N'India')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (460, 21, 0.022, N'Canada')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (461, 21, 0.023, N'United Kingdom')
INSERT [dbo].[Rankings] ([Id], [RankingId], [Proportion], [Country]) VALUES (462, 21, 0.701, N'United States')