You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-10-31 18:30:33 +03:00
4c9d6e39ac
* Restructured test suites and added autopilot and extended suites * Updated autopilot with correct branch - develop * Moved setup test case to a 'setup' directory, for consistency * Fixed a path issue * Updated some tests cases to keep up with development Co-authored-by: root <root@rocky8.localdomain>
1119 lines
32 KiB
Plaintext
1119 lines
32 KiB
Plaintext
USE tpch1;
|
|
select sum(l_discount) over() winsum, sum(l_discount) sum1, l_quantity * sum(l_discount) over () / sum(l_discount) div1 from lineitem group by l_discount, l_quantity order by l_discount, l_quantity;
|
|
winsum sum1 div1
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 0.00 NULL
|
|
27.50 110.43 0.24902653
|
|
27.50 109.93 0.50031838
|
|
27.50 109.57 0.75294332
|
|
27.50 109.24 1.00695716
|
|
27.50 108.19 1.27091228
|
|
27.50 108.87 1.51556903
|
|
27.50 108.18 1.77944167
|
|
27.50 109.04 2.01760822
|
|
27.50 108.03 2.29103027
|
|
27.50 110.83 2.48127763
|
|
27.50 108.20 2.79574861
|
|
27.50 109.11 3.02447072
|
|
27.50 107.78 3.31694192
|
|
27.50 107.41 3.58439624
|
|
27.50 109.60 3.76368613
|
|
27.50 109.87 4.00473287
|
|
27.50 107.84 4.33512611
|
|
27.50 107.29 4.61366390
|
|
27.50 110.13 4.74439299
|
|
27.50 109.26 5.03386418
|
|
27.50 107.74 5.36012623
|
|
27.50 109.97 5.50150041
|
|
27.50 110.21 5.73904364
|
|
27.50 109.83 6.00928708
|
|
27.50 111.05 6.19090500
|
|
27.50 108.77 6.57350372
|
|
27.50 109.60 6.77463504
|
|
27.50 109.03 7.06227644
|
|
27.50 109.72 7.26850164
|
|
27.50 108.98 7.57019637
|
|
27.50 108.02 7.89205703
|
|
27.50 109.65 8.02553580
|
|
27.50 112.31 8.08031342
|
|
27.50 107.40 8.70577281
|
|
27.50 108.94 8.83513861
|
|
27.50 110.35 8.97145446
|
|
27.50 108.99 9.33571887
|
|
27.50 110.05 9.49568378
|
|
27.50 109.31 9.81154515
|
|
27.50 109.07 10.08526634
|
|
27.50 107.86 10.45336547
|
|
27.50 110.62 10.44114988
|
|
27.50 110.15 10.73536087
|
|
27.50 107.09 11.29890746
|
|
27.50 107.81 11.47852704
|
|
27.50 111.14 11.38204067
|
|
27.50 110.14 11.73506446
|
|
27.50 109.79 12.02295291
|
|
27.50 109.07 12.35445127
|
|
27.50 106.88 12.86489521
|
|
27.50 218.00 0.12614679
|
|
27.50 213.24 0.25792534
|
|
27.50 221.44 0.37256142
|
|
27.50 217.36 0.50607287
|
|
27.50 215.68 0.63751855
|
|
27.50 217.10 0.76001842
|
|
27.50 218.60 0.88060384
|
|
27.50 216.68 1.01532213
|
|
27.50 218.42 1.13313799
|
|
27.50 217.80 1.26262626
|
|
27.50 219.18 1.38014417
|
|
27.50 216.50 1.52424942
|
|
27.50 218.98 1.63256918
|
|
27.50 216.06 1.78191243
|
|
27.50 220.90 1.86736080
|
|
27.50 219.50 2.00455581
|
|
27.50 221.92 2.10661500
|
|
27.50 219.16 2.25862384
|
|
27.50 219.16 2.38410294
|
|
27.50 216.74 2.53760266
|
|
27.50 215.20 2.68355019
|
|
27.50 220.84 2.73953994
|
|
27.50 222.44 2.84346341
|
|
27.50 217.20 3.03867403
|
|
27.50 221.20 3.10804702
|
|
27.50 221.32 3.23061630
|
|
27.50 219.94 3.37592071
|
|
27.50 214.70 3.58639963
|
|
27.50 219.58 3.63193369
|
|
27.50 214.62 3.84400335
|
|
27.50 216.46 3.93837199
|
|
27.50 226.50 3.88520971
|
|
27.50 216.30 4.19556172
|
|
27.50 218.78 4.27369961
|
|
27.50 217.86 4.41797485
|
|
27.50 217.48 4.55214273
|
|
27.50 216.92 4.69066937
|
|
27.50 222.34 4.70000900
|
|
27.50 216.08 4.96343947
|
|
27.50 222.44 4.94515375
|
|
27.50 219.46 5.13761050
|
|
27.50 219.04 5.27300950
|
|
27.50 216.90 5.45182112
|
|
27.50 219.96 5.50100018
|
|
27.50 215.26 5.74886184
|
|
27.50 219.06 5.77467361
|
|
27.50 218.88 5.90506213
|
|
27.50 219.06 6.02574637
|
|
27.50 214.12 6.29320007
|
|
27.50 221.10 6.21890547
|
|
27.50 325.08 0.08459456
|
|
27.50 324.24 0.16962744
|
|
27.50 326.46 0.25271090
|
|
27.50 322.50 0.34108527
|
|
27.50 327.15 0.42029650
|
|
27.50 320.10 0.51546392
|
|
27.50 326.01 0.59047268
|
|
27.50 329.64 0.66739473
|
|
27.50 329.76 0.75054585
|
|
27.50 325.62 0.84454272
|
|
27.50 324.21 0.93303723
|
|
27.50 324.21 1.01785880
|
|
27.50 325.92 1.09689494
|
|
27.50 326.64 1.17866765
|
|
27.50 326.67 1.26274222
|
|
27.50 323.70 1.35928329
|
|
27.50 328.11 1.42482704
|
|
27.50 328.20 1.50822669
|
|
27.50 325.59 1.60477902
|
|
27.50 328.92 1.67213912
|
|
27.50 333.72 1.73049263
|
|
27.50 328.02 1.84439973
|
|
27.50 326.55 1.93691625
|
|
27.50 333.81 1.97717264
|
|
27.50 330.60 2.07955233
|
|
27.50 325.17 2.19884983
|
|
27.50 325.86 2.27858590
|
|
27.50 326.61 2.35755182
|
|
27.50 328.77 2.42570794
|
|
27.50 326.28 2.52850313
|
|
27.50 330.57 2.57887891
|
|
27.50 326.64 2.69409748
|
|
27.50 327.27 2.77293977
|
|
27.50 333.00 2.80780781
|
|
27.50 323.07 2.97923051
|
|
27.50 330.87 2.99211171
|
|
27.50 328.44 3.09797832
|
|
27.50 324.30 3.22232501
|
|
27.50 327.66 3.27321003
|
|
27.50 320.46 3.43256569
|
|
27.50 331.80 3.39813140
|
|
27.50 331.05 3.48889896
|
|
27.50 330.75 3.57520786
|
|
27.50 330.93 3.65636237
|
|
27.50 323.04 3.83079495
|
|
27.50 324.39 3.89962699
|
|
27.50 324.39 3.98440149
|
|
27.50 327.84 4.02635432
|
|
27.50 330.54 4.07666243
|
|
27.50 327.66 4.19642312
|
|
27.50 436.48 0.06300403
|
|
27.50 434.60 0.12655315
|
|
27.50 439.12 0.18787575
|
|
27.50 438.48 0.25086663
|
|
27.50 438.64 0.31346890
|
|
27.50 434.96 0.37934523
|
|
27.50 431.40 0.44622160
|
|
27.50 427.84 0.51421092
|
|
27.50 440.88 0.56137725
|
|
27.50 429.84 0.63977294
|
|
27.50 436.44 0.69310787
|
|
27.50 441.08 0.74816360
|
|
27.50 445.88 0.80178523
|
|
27.50 438.32 0.87835371
|
|
27.50 439.96 0.93758524
|
|
27.50 442.44 0.99448513
|
|
27.50 432.52 1.08087487
|
|
27.50 433.20 1.14265928
|
|
27.50 437.04 1.19554274
|
|
27.50 445.16 1.23551083
|
|
27.50 442.08 1.30632465
|
|
27.50 427.04 1.41672911
|
|
27.50 434.60 1.45536125
|
|
27.50 432.72 1.52523572
|
|
27.50 441.40 1.55754418
|
|
27.50 431.00 1.65893271
|
|
27.50 430.24 1.72578096
|
|
27.50 442.92 1.73846293
|
|
27.50 438.56 1.81845130
|
|
27.50 442.48 1.86449105
|
|
27.50 439.44 1.93996905
|
|
27.50 438.48 2.00693304
|
|
27.50 427.80 2.12131837
|
|
27.50 435.16 2.14863498
|
|
27.50 438.04 2.19728792
|
|
27.50 440.88 2.24550898
|
|
27.50 427.44 2.38045106
|
|
27.50 432.24 2.41763835
|
|
27.50 430.80 2.48955432
|
|
27.50 441.24 2.49297435
|
|
27.50 447.72 2.51831502
|
|
27.50 435.20 2.65395221
|
|
27.50 432.04 2.73701509
|
|
27.50 438.16 2.76154829
|
|
27.50 431.24 2.86963176
|
|
27.50 434.24 2.91313559
|
|
27.50 441.20 2.92951043
|
|
27.50 435.40 3.03169499
|
|
27.50 436.76 3.08521843
|
|
27.50 431.00 3.19025522
|
|
27.50 545.85 0.05038014
|
|
27.50 548.00 0.10036496
|
|
27.50 551.80 0.14951069
|
|
27.50 533.35 0.20624355
|
|
27.50 547.75 0.25102693
|
|
27.50 543.45 0.30361579
|
|
27.50 546.00 0.35256410
|
|
27.50 540.95 0.40669193
|
|
27.50 553.15 0.44743740
|
|
27.50 546.85 0.50288013
|
|
27.50 543.60 0.55647535
|
|
27.50 548.80 0.60131195
|
|
27.50 540.30 0.66166944
|
|
27.50 540.45 0.71236932
|
|
27.50 545.50 0.75618698
|
|
27.50 549.75 0.80036380
|
|
27.50 547.30 0.85419331
|
|
27.50 538.75 0.91879350
|
|
27.50 559.40 0.93403647
|
|
27.50 546.35 1.00668070
|
|
27.50 542.40 1.06471239
|
|
27.50 543.60 1.11295070
|
|
27.50 552.50 1.14479638
|
|
27.50 535.75 1.23191787
|
|
27.50 542.25 1.26786538
|
|
27.50 544.15 1.31397593
|
|
27.50 550.85 1.34791686
|
|
27.50 548.30 1.40434069
|
|
27.50 539.80 1.47739904
|
|
27.50 542.80 1.51989683
|
|
27.50 543.65 1.56810448
|
|
27.50 550.35 1.59898247
|
|
27.50 549.45 1.65165165
|
|
27.50 547.65 1.70729481
|
|
27.50 546.90 1.75991955
|
|
27.50 544.25 1.81901700
|
|
27.50 552.00 1.84329710
|
|
27.50 558.85 1.86991143
|
|
27.50 550.30 1.94893694
|
|
27.50 552.70 1.99022978
|
|
27.50 544.20 2.07184859
|
|
27.50 555.90 2.07771182
|
|
27.50 542.50 2.17972350
|
|
27.50 546.35 2.21469754
|
|
27.50 545.15 2.27001743
|
|
27.50 548.20 2.30755199
|
|
27.50 550.30 2.34871888
|
|
27.50 549.60 2.40174672
|
|
27.50 540.30 2.49398482
|
|
27.50 541.40 2.53971186
|
|
27.50 658.74 0.04174636
|
|
27.50 645.72 0.08517624
|
|
27.50 650.22 0.12688013
|
|
27.50 656.34 0.16759606
|
|
27.50 653.82 0.21030253
|
|
27.50 652.68 0.25280382
|
|
27.50 656.34 0.29329311
|
|
27.50 659.22 0.33372774
|
|
27.50 661.62 0.37408180
|
|
27.50 652.92 0.42118483
|
|
27.50 655.02 0.46181796
|
|
27.50 652.86 0.50546825
|
|
27.50 654.36 0.54633535
|
|
27.50 647.70 0.59441099
|
|
27.50 649.20 0.63539741
|
|
27.50 653.52 0.67327702
|
|
27.50 653.64 0.71522551
|
|
27.50 644.82 0.76765609
|
|
27.50 643.86 0.81151182
|
|
27.50 654.48 0.84036181
|
|
27.50 649.74 0.88881707
|
|
27.50 650.10 0.93062606
|
|
27.50 660.60 0.95746291
|
|
27.50 659.10 1.00136550
|
|
27.50 652.56 1.05354297
|
|
27.50 657.72 1.08708873
|
|
27.50 641.70 1.15708275
|
|
27.50 654.42 1.17661441
|
|
27.50 657.48 1.21296465
|
|
27.50 652.74 1.26390293
|
|
27.50 662.94 1.28593840
|
|
27.50 656.16 1.34113631
|
|
27.50 652.98 1.38978223
|
|
27.50 654.72 1.42809140
|
|
27.50 660.06 1.45820077
|
|
27.50 654.84 1.51181968
|
|
27.50 658.68 1.54475618
|
|
27.50 659.82 1.58376527
|
|
27.50 659.10 1.62721893
|
|
27.50 653.88 1.68226586
|
|
27.50 643.86 1.75115708
|
|
27.50 649.62 1.77796250
|
|
27.50 656.22 1.80198714
|
|
27.50 651.42 1.85748058
|
|
27.50 662.70 1.86736080
|
|
27.50 651.66 1.94119633
|
|
27.50 648.66 1.99256930
|
|
27.50 660.66 1.99800200
|
|
27.50 662.94 2.03261230
|
|
27.50 644.04 2.13496056
|
|
27.50 773.92 0.03553339
|
|
27.50 754.95 0.07285251
|
|
27.50 766.43 0.10764192
|
|
27.50 752.64 0.14615221
|
|
27.50 754.60 0.18221574
|
|
27.50 767.41 0.21500893
|
|
27.50 759.85 0.25333947
|
|
27.50 769.65 0.28584421
|
|
27.50 760.48 0.32545235
|
|
27.50 761.53 0.36111512
|
|
27.50 764.47 0.39569898
|
|
27.50 762.93 0.43254296
|
|
27.50 764.54 0.46760143
|
|
27.50 767.62 0.50155025
|
|
27.50 770.21 0.53556822
|
|
27.50 766.92 0.57372347
|
|
27.50 768.18 0.60858132
|
|
27.50 770.00 0.64285714
|
|
27.50 767.62 0.68067533
|
|
27.50 761.67 0.72209750
|
|
27.50 754.67 0.76523514
|
|
27.50 760.13 0.79591649
|
|
27.50 758.38 0.83401461
|
|
27.50 762.23 0.86588038
|
|
27.50 768.18 0.89497253
|
|
27.50 757.40 0.94401901
|
|
27.50 771.19 0.96279775
|
|
27.50 770.42 0.99945484
|
|
27.50 768.04 1.03835738
|
|
27.50 763.07 1.08115900
|
|
27.50 755.02 1.12910916
|
|
27.50 775.67 1.13450307
|
|
27.50 757.54 1.19795654
|
|
27.50 774.48 1.20726165
|
|
27.50 784.98 1.22614589
|
|
27.50 761.74 1.29965605
|
|
27.50 759.64 1.33945027
|
|
27.50 754.81 1.38445437
|
|
27.50 767.83 1.39679356
|
|
27.50 763.07 1.44154534
|
|
27.50 767.55 1.46895968
|
|
27.50 757.26 1.52523572
|
|
27.50 764.82 1.54611543
|
|
27.50 760.55 1.59095391
|
|
27.50 774.62 1.59755751
|
|
27.50 762.02 1.66006142
|
|
27.50 779.03 1.65911454
|
|
27.50 765.80 1.72368765
|
|
27.50 760.20 1.77255985
|
|
27.50 767.48 1.79157763
|
|
27.50 873.04 0.03149913
|
|
27.50 871.04 0.06314291
|
|
27.50 878.40 0.09392077
|
|
27.50 881.44 0.12479579
|
|
27.50 878.32 0.15654887
|
|
27.50 858.24 0.19225391
|
|
27.50 873.36 0.22041312
|
|
27.50 872.56 0.25213166
|
|
27.50 888.56 0.27854056
|
|
27.50 865.28 0.31781620
|
|
27.50 872.16 0.34684003
|
|
27.50 867.52 0.38039469
|
|
27.50 871.12 0.41039122
|
|
27.50 849.92 0.45298381
|
|
27.50 879.52 0.46900582
|
|
27.50 876.64 0.50191641
|
|
27.50 886.40 0.52741426
|
|
27.50 860.64 0.57515337
|
|
27.50 870.32 0.60035389
|
|
27.50 871.20 0.63131313
|
|
27.50 879.92 0.65630966
|
|
27.50 876.48 0.69026104
|
|
27.50 886.32 0.71362488
|
|
27.50 878.16 0.75157147
|
|
27.50 865.76 0.79409998
|
|
27.50 877.28 0.81501915
|
|
27.50 866.48 0.85691534
|
|
27.50 876.80 0.87819343
|
|
27.50 854.88 0.93287947
|
|
27.50 870.72 0.94749173
|
|
27.50 867.36 0.98286755
|
|
27.50 862.08 1.02078693
|
|
27.50 885.20 1.02519205
|
|
27.50 862.00 1.08468677
|
|
27.50 884.08 1.08870238
|
|
27.50 869.36 1.13876875
|
|
27.50 884.00 1.15101810
|
|
27.50 865.60 1.20725508
|
|
27.50 877.76 1.22186019
|
|
27.50 857.12 1.28336756
|
|
27.50 878.00 1.28416856
|
|
27.50 865.52 1.33445790
|
|
27.50 879.44 1.34460566
|
|
27.50 883.20 1.37001812
|
|
27.50 873.76 1.41629280
|
|
27.50 873.04 1.44895996
|
|
27.50 858.96 1.50472665
|
|
27.50 857.60 1.53917910
|
|
27.50 860.32 1.56627766
|
|
27.50 861.36 1.59631281
|
|
27.50 986.67 0.02787153
|
|
27.50 978.66 0.05619929
|
|
27.50 973.08 0.08478234
|
|
27.50 990.45 0.11106063
|
|
27.50 973.26 0.14127777
|
|
27.50 983.43 0.16778012
|
|
27.50 984.24 0.19558238
|
|
27.50 1004.22 0.21907550
|
|
27.50 985.95 0.25102693
|
|
27.50 986.58 0.27874070
|
|
27.50 975.87 0.30997981
|
|
27.50 982.71 0.33580609
|
|
27.50 963.72 0.37095837
|
|
27.50 999.81 0.38507316
|
|
27.50 976.68 0.42234918
|
|
27.50 984.69 0.44684114
|
|
27.50 978.48 0.47778187
|
|
27.50 972.27 0.50911784
|
|
27.50 968.58 0.53944950
|
|
27.50 975.69 0.56370364
|
|
27.50 974.43 0.59265417
|
|
27.50 984.51 0.61451890
|
|
27.50 985.14 0.64204073
|
|
27.50 980.73 0.67296810
|
|
27.50 986.49 0.69691533
|
|
27.50 986.04 0.72512271
|
|
27.50 989.73 0.75020460
|
|
27.50 976.95 0.78816726
|
|
27.50 976.41 0.81676755
|
|
27.50 977.22 0.84423160
|
|
27.50 982.35 0.86781697
|
|
27.50 965.70 0.91125608
|
|
27.50 990.00 0.91666667
|
|
27.50 978.12 0.95591543
|
|
27.50 994.23 0.96808586
|
|
27.50 986.85 1.00319197
|
|
27.50 989.82 1.02796468
|
|
27.50 972.27 1.07480432
|
|
27.50 986.67 1.08698957
|
|
27.50 976.23 1.12678365
|
|
27.50 975.33 1.15601899
|
|
27.50 982.17 1.17596750
|
|
27.50 976.05 1.21151580
|
|
27.50 970.47 1.24681855
|
|
27.50 974.79 1.26950420
|
|
27.50 1000.62 1.26421619
|
|
27.50 976.77 1.32323884
|
|
27.50 978.39 1.34915524
|
|
27.50 983.43 1.37020429
|
|
27.50 994.86 1.38210401
|
|
27.50 1097.40 0.02505923
|
|
27.50 1102.00 0.04990926
|
|
27.50 1085.80 0.07598084
|
|
27.50 1088.30 0.10107507
|
|
27.50 1076.80 0.12769316
|
|
27.50 1090.20 0.15134838
|
|
27.50 1124.20 0.17123288
|
|
27.50 1103.70 0.19932953
|
|
27.50 1095.10 0.22600676
|
|
27.50 1086.80 0.25303644
|
|
27.50 1080.90 0.27985938
|
|
27.50 1085.30 0.30406339
|
|
27.50 1091.00 0.32768103
|
|
27.50 1086.70 0.35428361
|
|
27.50 1088.00 0.37913603
|
|
27.50 1099.00 0.40036397
|
|
27.50 1090.90 0.42854524
|
|
27.50 1099.60 0.45016370
|
|
27.50 1103.00 0.47370807
|
|
27.50 1075.10 0.51158032
|
|
27.50 1112.60 0.51905447
|
|
27.50 1090.90 0.55458795
|
|
27.50 1084.20 0.58337945
|
|
27.50 1082.70 0.60958714
|
|
27.50 1095.20 0.62773923
|
|
27.50 1067.00 0.67010309
|
|
27.50 1089.90 0.68125516
|
|
27.50 1103.30 0.69790628
|
|
27.50 1089.70 0.73185280
|
|
27.50 1078.20 0.76516416
|
|
27.50 1089.20 0.78268454
|
|
27.50 1104.10 0.79702925
|
|
27.50 1077.80 0.84199295
|
|
27.50 1089.60 0.85811307
|
|
27.50 1104.40 0.87151394
|
|
27.50 1101.20 0.89901925
|
|
27.50 1095.70 0.92863010
|
|
27.50 1098.40 0.95138383
|
|
27.50 1080.80 0.99232050
|
|
27.50 1086.10 1.01279808
|
|
27.50 1104.90 1.02045434
|
|
27.50 1103.60 1.04657485
|
|
27.50 1071.70 1.10338714
|
|
27.50 1090.80 1.10927759
|
|
27.50 1077.80 1.14817220
|
|
27.50 1095.90 1.15430240
|
|
27.50 1086.60 1.18949015
|
|
27.50 1103.80 1.19586882
|
|
27.50 1082.10 1.24526384
|
|
27.50 1093.50 1.25743027
|
|
select l_discount, sum(l_discount) over() / l_discount from lineitem group by l_discount order by l_discount;
|
|
l_discount sum(l_discount) over() / l_discount
|
|
0.00 NULL
|
|
0.01 55.000000
|
|
0.02 27.500000
|
|
0.03 18.333333
|
|
0.04 13.750000
|
|
0.05 11.000000
|
|
0.06 9.166667
|
|
0.07 7.857143
|
|
0.08 6.875000
|
|
0.09 6.111111
|
|
0.10 5.500000
|
|
select l_quantity, l_discount,sum(l_discount) over() winsum, sum(l_discount) sum1, l_quantity * sum(l_discount) over () / sum(l_discount) div1 from lineitem group by l_discount, l_quantity order by l_quantity, l_discount;
|
|
l_quantity l_discount winsum sum1 div1
|
|
1.00 0.00 27.50 0.00 NULL
|
|
1.00 0.01 27.50 110.43 0.24902653
|
|
1.00 0.02 27.50 218.00 0.12614679
|
|
1.00 0.03 27.50 325.08 0.08459456
|
|
1.00 0.04 27.50 436.48 0.06300403
|
|
1.00 0.05 27.50 545.85 0.05038014
|
|
1.00 0.06 27.50 658.74 0.04174636
|
|
1.00 0.07 27.50 773.92 0.03553339
|
|
1.00 0.08 27.50 873.04 0.03149913
|
|
1.00 0.09 27.50 986.67 0.02787153
|
|
1.00 0.10 27.50 1097.40 0.02505923
|
|
2.00 0.00 27.50 0.00 NULL
|
|
2.00 0.01 27.50 109.93 0.50031838
|
|
2.00 0.02 27.50 213.24 0.25792534
|
|
2.00 0.03 27.50 324.24 0.16962744
|
|
2.00 0.04 27.50 434.60 0.12655315
|
|
2.00 0.05 27.50 548.00 0.10036496
|
|
2.00 0.06 27.50 645.72 0.08517624
|
|
2.00 0.07 27.50 754.95 0.07285251
|
|
2.00 0.08 27.50 871.04 0.06314291
|
|
2.00 0.09 27.50 978.66 0.05619929
|
|
2.00 0.10 27.50 1102.00 0.04990926
|
|
3.00 0.00 27.50 0.00 NULL
|
|
3.00 0.01 27.50 109.57 0.75294332
|
|
3.00 0.02 27.50 221.44 0.37256142
|
|
3.00 0.03 27.50 326.46 0.25271090
|
|
3.00 0.04 27.50 439.12 0.18787575
|
|
3.00 0.05 27.50 551.80 0.14951069
|
|
3.00 0.06 27.50 650.22 0.12688013
|
|
3.00 0.07 27.50 766.43 0.10764192
|
|
3.00 0.08 27.50 878.40 0.09392077
|
|
3.00 0.09 27.50 973.08 0.08478234
|
|
3.00 0.10 27.50 1085.80 0.07598084
|
|
4.00 0.00 27.50 0.00 NULL
|
|
4.00 0.01 27.50 109.24 1.00695716
|
|
4.00 0.02 27.50 217.36 0.50607287
|
|
4.00 0.03 27.50 322.50 0.34108527
|
|
4.00 0.04 27.50 438.48 0.25086663
|
|
4.00 0.05 27.50 533.35 0.20624355
|
|
4.00 0.06 27.50 656.34 0.16759606
|
|
4.00 0.07 27.50 752.64 0.14615221
|
|
4.00 0.08 27.50 881.44 0.12479579
|
|
4.00 0.09 27.50 990.45 0.11106063
|
|
4.00 0.10 27.50 1088.30 0.10107507
|
|
5.00 0.00 27.50 0.00 NULL
|
|
5.00 0.01 27.50 108.19 1.27091228
|
|
5.00 0.02 27.50 215.68 0.63751855
|
|
5.00 0.03 27.50 327.15 0.42029650
|
|
5.00 0.04 27.50 438.64 0.31346890
|
|
5.00 0.05 27.50 547.75 0.25102693
|
|
5.00 0.06 27.50 653.82 0.21030253
|
|
5.00 0.07 27.50 754.60 0.18221574
|
|
5.00 0.08 27.50 878.32 0.15654887
|
|
5.00 0.09 27.50 973.26 0.14127777
|
|
5.00 0.10 27.50 1076.80 0.12769316
|
|
6.00 0.00 27.50 0.00 NULL
|
|
6.00 0.01 27.50 108.87 1.51556903
|
|
6.00 0.02 27.50 217.10 0.76001842
|
|
6.00 0.03 27.50 320.10 0.51546392
|
|
6.00 0.04 27.50 434.96 0.37934523
|
|
6.00 0.05 27.50 543.45 0.30361579
|
|
6.00 0.06 27.50 652.68 0.25280382
|
|
6.00 0.07 27.50 767.41 0.21500893
|
|
6.00 0.08 27.50 858.24 0.19225391
|
|
6.00 0.09 27.50 983.43 0.16778012
|
|
6.00 0.10 27.50 1090.20 0.15134838
|
|
7.00 0.00 27.50 0.00 NULL
|
|
7.00 0.01 27.50 108.18 1.77944167
|
|
7.00 0.02 27.50 218.60 0.88060384
|
|
7.00 0.03 27.50 326.01 0.59047268
|
|
7.00 0.04 27.50 431.40 0.44622160
|
|
7.00 0.05 27.50 546.00 0.35256410
|
|
7.00 0.06 27.50 656.34 0.29329311
|
|
7.00 0.07 27.50 759.85 0.25333947
|
|
7.00 0.08 27.50 873.36 0.22041312
|
|
7.00 0.09 27.50 984.24 0.19558238
|
|
7.00 0.10 27.50 1124.20 0.17123288
|
|
8.00 0.00 27.50 0.00 NULL
|
|
8.00 0.01 27.50 109.04 2.01760822
|
|
8.00 0.02 27.50 216.68 1.01532213
|
|
8.00 0.03 27.50 329.64 0.66739473
|
|
8.00 0.04 27.50 427.84 0.51421092
|
|
8.00 0.05 27.50 540.95 0.40669193
|
|
8.00 0.06 27.50 659.22 0.33372774
|
|
8.00 0.07 27.50 769.65 0.28584421
|
|
8.00 0.08 27.50 872.56 0.25213166
|
|
8.00 0.09 27.50 1004.22 0.21907550
|
|
8.00 0.10 27.50 1103.70 0.19932953
|
|
9.00 0.00 27.50 0.00 NULL
|
|
9.00 0.01 27.50 108.03 2.29103027
|
|
9.00 0.02 27.50 218.42 1.13313799
|
|
9.00 0.03 27.50 329.76 0.75054585
|
|
9.00 0.04 27.50 440.88 0.56137725
|
|
9.00 0.05 27.50 553.15 0.44743740
|
|
9.00 0.06 27.50 661.62 0.37408180
|
|
9.00 0.07 27.50 760.48 0.32545235
|
|
9.00 0.08 27.50 888.56 0.27854056
|
|
9.00 0.09 27.50 985.95 0.25102693
|
|
9.00 0.10 27.50 1095.10 0.22600676
|
|
10.00 0.00 27.50 0.00 NULL
|
|
10.00 0.01 27.50 110.83 2.48127763
|
|
10.00 0.02 27.50 217.80 1.26262626
|
|
10.00 0.03 27.50 325.62 0.84454272
|
|
10.00 0.04 27.50 429.84 0.63977294
|
|
10.00 0.05 27.50 546.85 0.50288013
|
|
10.00 0.06 27.50 652.92 0.42118483
|
|
10.00 0.07 27.50 761.53 0.36111512
|
|
10.00 0.08 27.50 865.28 0.31781620
|
|
10.00 0.09 27.50 986.58 0.27874070
|
|
10.00 0.10 27.50 1086.80 0.25303644
|
|
11.00 0.00 27.50 0.00 NULL
|
|
11.00 0.01 27.50 108.20 2.79574861
|
|
11.00 0.02 27.50 219.18 1.38014417
|
|
11.00 0.03 27.50 324.21 0.93303723
|
|
11.00 0.04 27.50 436.44 0.69310787
|
|
11.00 0.05 27.50 543.60 0.55647535
|
|
11.00 0.06 27.50 655.02 0.46181796
|
|
11.00 0.07 27.50 764.47 0.39569898
|
|
11.00 0.08 27.50 872.16 0.34684003
|
|
11.00 0.09 27.50 975.87 0.30997981
|
|
11.00 0.10 27.50 1080.90 0.27985938
|
|
12.00 0.00 27.50 0.00 NULL
|
|
12.00 0.01 27.50 109.11 3.02447072
|
|
12.00 0.02 27.50 216.50 1.52424942
|
|
12.00 0.03 27.50 324.21 1.01785880
|
|
12.00 0.04 27.50 441.08 0.74816360
|
|
12.00 0.05 27.50 548.80 0.60131195
|
|
12.00 0.06 27.50 652.86 0.50546825
|
|
12.00 0.07 27.50 762.93 0.43254296
|
|
12.00 0.08 27.50 867.52 0.38039469
|
|
12.00 0.09 27.50 982.71 0.33580609
|
|
12.00 0.10 27.50 1085.30 0.30406339
|
|
13.00 0.00 27.50 0.00 NULL
|
|
13.00 0.01 27.50 107.78 3.31694192
|
|
13.00 0.02 27.50 218.98 1.63256918
|
|
13.00 0.03 27.50 325.92 1.09689494
|
|
13.00 0.04 27.50 445.88 0.80178523
|
|
13.00 0.05 27.50 540.30 0.66166944
|
|
13.00 0.06 27.50 654.36 0.54633535
|
|
13.00 0.07 27.50 764.54 0.46760143
|
|
13.00 0.08 27.50 871.12 0.41039122
|
|
13.00 0.09 27.50 963.72 0.37095837
|
|
13.00 0.10 27.50 1091.00 0.32768103
|
|
14.00 0.00 27.50 0.00 NULL
|
|
14.00 0.01 27.50 107.41 3.58439624
|
|
14.00 0.02 27.50 216.06 1.78191243
|
|
14.00 0.03 27.50 326.64 1.17866765
|
|
14.00 0.04 27.50 438.32 0.87835371
|
|
14.00 0.05 27.50 540.45 0.71236932
|
|
14.00 0.06 27.50 647.70 0.59441099
|
|
14.00 0.07 27.50 767.62 0.50155025
|
|
14.00 0.08 27.50 849.92 0.45298381
|
|
14.00 0.09 27.50 999.81 0.38507316
|
|
14.00 0.10 27.50 1086.70 0.35428361
|
|
15.00 0.00 27.50 0.00 NULL
|
|
15.00 0.01 27.50 109.60 3.76368613
|
|
15.00 0.02 27.50 220.90 1.86736080
|
|
15.00 0.03 27.50 326.67 1.26274222
|
|
15.00 0.04 27.50 439.96 0.93758524
|
|
15.00 0.05 27.50 545.50 0.75618698
|
|
15.00 0.06 27.50 649.20 0.63539741
|
|
15.00 0.07 27.50 770.21 0.53556822
|
|
15.00 0.08 27.50 879.52 0.46900582
|
|
15.00 0.09 27.50 976.68 0.42234918
|
|
15.00 0.10 27.50 1088.00 0.37913603
|
|
16.00 0.00 27.50 0.00 NULL
|
|
16.00 0.01 27.50 109.87 4.00473287
|
|
16.00 0.02 27.50 219.50 2.00455581
|
|
16.00 0.03 27.50 323.70 1.35928329
|
|
16.00 0.04 27.50 442.44 0.99448513
|
|
16.00 0.05 27.50 549.75 0.80036380
|
|
16.00 0.06 27.50 653.52 0.67327702
|
|
16.00 0.07 27.50 766.92 0.57372347
|
|
16.00 0.08 27.50 876.64 0.50191641
|
|
16.00 0.09 27.50 984.69 0.44684114
|
|
16.00 0.10 27.50 1099.00 0.40036397
|
|
17.00 0.00 27.50 0.00 NULL
|
|
17.00 0.01 27.50 107.84 4.33512611
|
|
17.00 0.02 27.50 221.92 2.10661500
|
|
17.00 0.03 27.50 328.11 1.42482704
|
|
17.00 0.04 27.50 432.52 1.08087487
|
|
17.00 0.05 27.50 547.30 0.85419331
|
|
17.00 0.06 27.50 653.64 0.71522551
|
|
17.00 0.07 27.50 768.18 0.60858132
|
|
17.00 0.08 27.50 886.40 0.52741426
|
|
17.00 0.09 27.50 978.48 0.47778187
|
|
17.00 0.10 27.50 1090.90 0.42854524
|
|
18.00 0.00 27.50 0.00 NULL
|
|
18.00 0.01 27.50 107.29 4.61366390
|
|
18.00 0.02 27.50 219.16 2.25862384
|
|
18.00 0.03 27.50 328.20 1.50822669
|
|
18.00 0.04 27.50 433.20 1.14265928
|
|
18.00 0.05 27.50 538.75 0.91879350
|
|
18.00 0.06 27.50 644.82 0.76765609
|
|
18.00 0.07 27.50 770.00 0.64285714
|
|
18.00 0.08 27.50 860.64 0.57515337
|
|
18.00 0.09 27.50 972.27 0.50911784
|
|
18.00 0.10 27.50 1099.60 0.45016370
|
|
19.00 0.00 27.50 0.00 NULL
|
|
19.00 0.01 27.50 110.13 4.74439299
|
|
19.00 0.02 27.50 219.16 2.38410294
|
|
19.00 0.03 27.50 325.59 1.60477902
|
|
19.00 0.04 27.50 437.04 1.19554274
|
|
19.00 0.05 27.50 559.40 0.93403647
|
|
19.00 0.06 27.50 643.86 0.81151182
|
|
19.00 0.07 27.50 767.62 0.68067533
|
|
19.00 0.08 27.50 870.32 0.60035389
|
|
19.00 0.09 27.50 968.58 0.53944950
|
|
19.00 0.10 27.50 1103.00 0.47370807
|
|
20.00 0.00 27.50 0.00 NULL
|
|
20.00 0.01 27.50 109.26 5.03386418
|
|
20.00 0.02 27.50 216.74 2.53760266
|
|
20.00 0.03 27.50 328.92 1.67213912
|
|
20.00 0.04 27.50 445.16 1.23551083
|
|
20.00 0.05 27.50 546.35 1.00668070
|
|
20.00 0.06 27.50 654.48 0.84036181
|
|
20.00 0.07 27.50 761.67 0.72209750
|
|
20.00 0.08 27.50 871.20 0.63131313
|
|
20.00 0.09 27.50 975.69 0.56370364
|
|
20.00 0.10 27.50 1075.10 0.51158032
|
|
21.00 0.00 27.50 0.00 NULL
|
|
21.00 0.01 27.50 107.74 5.36012623
|
|
21.00 0.02 27.50 215.20 2.68355019
|
|
21.00 0.03 27.50 333.72 1.73049263
|
|
21.00 0.04 27.50 442.08 1.30632465
|
|
21.00 0.05 27.50 542.40 1.06471239
|
|
21.00 0.06 27.50 649.74 0.88881707
|
|
21.00 0.07 27.50 754.67 0.76523514
|
|
21.00 0.08 27.50 879.92 0.65630966
|
|
21.00 0.09 27.50 974.43 0.59265417
|
|
21.00 0.10 27.50 1112.60 0.51905447
|
|
22.00 0.00 27.50 0.00 NULL
|
|
22.00 0.01 27.50 109.97 5.50150041
|
|
22.00 0.02 27.50 220.84 2.73953994
|
|
22.00 0.03 27.50 328.02 1.84439973
|
|
22.00 0.04 27.50 427.04 1.41672911
|
|
22.00 0.05 27.50 543.60 1.11295070
|
|
22.00 0.06 27.50 650.10 0.93062606
|
|
22.00 0.07 27.50 760.13 0.79591649
|
|
22.00 0.08 27.50 876.48 0.69026104
|
|
22.00 0.09 27.50 984.51 0.61451890
|
|
22.00 0.10 27.50 1090.90 0.55458795
|
|
23.00 0.00 27.50 0.00 NULL
|
|
23.00 0.01 27.50 110.21 5.73904364
|
|
23.00 0.02 27.50 222.44 2.84346341
|
|
23.00 0.03 27.50 326.55 1.93691625
|
|
23.00 0.04 27.50 434.60 1.45536125
|
|
23.00 0.05 27.50 552.50 1.14479638
|
|
23.00 0.06 27.50 660.60 0.95746291
|
|
23.00 0.07 27.50 758.38 0.83401461
|
|
23.00 0.08 27.50 886.32 0.71362488
|
|
23.00 0.09 27.50 985.14 0.64204073
|
|
23.00 0.10 27.50 1084.20 0.58337945
|
|
24.00 0.00 27.50 0.00 NULL
|
|
24.00 0.01 27.50 109.83 6.00928708
|
|
24.00 0.02 27.50 217.20 3.03867403
|
|
24.00 0.03 27.50 333.81 1.97717264
|
|
24.00 0.04 27.50 432.72 1.52523572
|
|
24.00 0.05 27.50 535.75 1.23191787
|
|
24.00 0.06 27.50 659.10 1.00136550
|
|
24.00 0.07 27.50 762.23 0.86588038
|
|
24.00 0.08 27.50 878.16 0.75157147
|
|
24.00 0.09 27.50 980.73 0.67296810
|
|
24.00 0.10 27.50 1082.70 0.60958714
|
|
25.00 0.00 27.50 0.00 NULL
|
|
25.00 0.01 27.50 111.05 6.19090500
|
|
25.00 0.02 27.50 221.20 3.10804702
|
|
25.00 0.03 27.50 330.60 2.07955233
|
|
25.00 0.04 27.50 441.40 1.55754418
|
|
25.00 0.05 27.50 542.25 1.26786538
|
|
25.00 0.06 27.50 652.56 1.05354297
|
|
25.00 0.07 27.50 768.18 0.89497253
|
|
25.00 0.08 27.50 865.76 0.79409998
|
|
25.00 0.09 27.50 986.49 0.69691533
|
|
25.00 0.10 27.50 1095.20 0.62773923
|
|
26.00 0.00 27.50 0.00 NULL
|
|
26.00 0.01 27.50 108.77 6.57350372
|
|
26.00 0.02 27.50 221.32 3.23061630
|
|
26.00 0.03 27.50 325.17 2.19884983
|
|
26.00 0.04 27.50 431.00 1.65893271
|
|
26.00 0.05 27.50 544.15 1.31397593
|
|
26.00 0.06 27.50 657.72 1.08708873
|
|
26.00 0.07 27.50 757.40 0.94401901
|
|
26.00 0.08 27.50 877.28 0.81501915
|
|
26.00 0.09 27.50 986.04 0.72512271
|
|
26.00 0.10 27.50 1067.00 0.67010309
|
|
27.00 0.00 27.50 0.00 NULL
|
|
27.00 0.01 27.50 109.60 6.77463504
|
|
27.00 0.02 27.50 219.94 3.37592071
|
|
27.00 0.03 27.50 325.86 2.27858590
|
|
27.00 0.04 27.50 430.24 1.72578096
|
|
27.00 0.05 27.50 550.85 1.34791686
|
|
27.00 0.06 27.50 641.70 1.15708275
|
|
27.00 0.07 27.50 771.19 0.96279775
|
|
27.00 0.08 27.50 866.48 0.85691534
|
|
27.00 0.09 27.50 989.73 0.75020460
|
|
27.00 0.10 27.50 1089.90 0.68125516
|
|
28.00 0.00 27.50 0.00 NULL
|
|
28.00 0.01 27.50 109.03 7.06227644
|
|
28.00 0.02 27.50 214.70 3.58639963
|
|
28.00 0.03 27.50 326.61 2.35755182
|
|
28.00 0.04 27.50 442.92 1.73846293
|
|
28.00 0.05 27.50 548.30 1.40434069
|
|
28.00 0.06 27.50 654.42 1.17661441
|
|
28.00 0.07 27.50 770.42 0.99945484
|
|
28.00 0.08 27.50 876.80 0.87819343
|
|
28.00 0.09 27.50 976.95 0.78816726
|
|
28.00 0.10 27.50 1103.30 0.69790628
|
|
29.00 0.00 27.50 0.00 NULL
|
|
29.00 0.01 27.50 109.72 7.26850164
|
|
29.00 0.02 27.50 219.58 3.63193369
|
|
29.00 0.03 27.50 328.77 2.42570794
|
|
29.00 0.04 27.50 438.56 1.81845130
|
|
29.00 0.05 27.50 539.80 1.47739904
|
|
29.00 0.06 27.50 657.48 1.21296465
|
|
29.00 0.07 27.50 768.04 1.03835738
|
|
29.00 0.08 27.50 854.88 0.93287947
|
|
29.00 0.09 27.50 976.41 0.81676755
|
|
29.00 0.10 27.50 1089.70 0.73185280
|
|
30.00 0.00 27.50 0.00 NULL
|
|
30.00 0.01 27.50 108.98 7.57019637
|
|
30.00 0.02 27.50 214.62 3.84400335
|
|
30.00 0.03 27.50 326.28 2.52850313
|
|
30.00 0.04 27.50 442.48 1.86449105
|
|
30.00 0.05 27.50 542.80 1.51989683
|
|
30.00 0.06 27.50 652.74 1.26390293
|
|
30.00 0.07 27.50 763.07 1.08115900
|
|
30.00 0.08 27.50 870.72 0.94749173
|
|
30.00 0.09 27.50 977.22 0.84423160
|
|
30.00 0.10 27.50 1078.20 0.76516416
|
|
31.00 0.00 27.50 0.00 NULL
|
|
31.00 0.01 27.50 108.02 7.89205703
|
|
31.00 0.02 27.50 216.46 3.93837199
|
|
31.00 0.03 27.50 330.57 2.57887891
|
|
31.00 0.04 27.50 439.44 1.93996905
|
|
31.00 0.05 27.50 543.65 1.56810448
|
|
31.00 0.06 27.50 662.94 1.28593840
|
|
31.00 0.07 27.50 755.02 1.12910916
|
|
31.00 0.08 27.50 867.36 0.98286755
|
|
31.00 0.09 27.50 982.35 0.86781697
|
|
31.00 0.10 27.50 1089.20 0.78268454
|
|
32.00 0.00 27.50 0.00 NULL
|
|
32.00 0.01 27.50 109.65 8.02553580
|
|
32.00 0.02 27.50 226.50 3.88520971
|
|
32.00 0.03 27.50 326.64 2.69409748
|
|
32.00 0.04 27.50 438.48 2.00693304
|
|
32.00 0.05 27.50 550.35 1.59898247
|
|
32.00 0.06 27.50 656.16 1.34113631
|
|
32.00 0.07 27.50 775.67 1.13450307
|
|
32.00 0.08 27.50 862.08 1.02078693
|
|
32.00 0.09 27.50 965.70 0.91125608
|
|
32.00 0.10 27.50 1104.10 0.79702925
|
|
33.00 0.00 27.50 0.00 NULL
|
|
33.00 0.01 27.50 112.31 8.08031342
|
|
33.00 0.02 27.50 216.30 4.19556172
|
|
33.00 0.03 27.50 327.27 2.77293977
|
|
33.00 0.04 27.50 427.80 2.12131837
|
|
33.00 0.05 27.50 549.45 1.65165165
|
|
33.00 0.06 27.50 652.98 1.38978223
|
|
33.00 0.07 27.50 757.54 1.19795654
|
|
33.00 0.08 27.50 885.20 1.02519205
|
|
33.00 0.09 27.50 990.00 0.91666667
|
|
33.00 0.10 27.50 1077.80 0.84199295
|
|
34.00 0.00 27.50 0.00 NULL
|
|
34.00 0.01 27.50 107.40 8.70577281
|
|
34.00 0.02 27.50 218.78 4.27369961
|
|
34.00 0.03 27.50 333.00 2.80780781
|
|
34.00 0.04 27.50 435.16 2.14863498
|
|
34.00 0.05 27.50 547.65 1.70729481
|
|
34.00 0.06 27.50 654.72 1.42809140
|
|
34.00 0.07 27.50 774.48 1.20726165
|
|
34.00 0.08 27.50 862.00 1.08468677
|
|
34.00 0.09 27.50 978.12 0.95591543
|
|
34.00 0.10 27.50 1089.60 0.85811307
|
|
35.00 0.00 27.50 0.00 NULL
|
|
35.00 0.01 27.50 108.94 8.83513861
|
|
35.00 0.02 27.50 217.86 4.41797485
|
|
35.00 0.03 27.50 323.07 2.97923051
|
|
35.00 0.04 27.50 438.04 2.19728792
|
|
35.00 0.05 27.50 546.90 1.75991955
|
|
35.00 0.06 27.50 660.06 1.45820077
|
|
35.00 0.07 27.50 784.98 1.22614589
|
|
35.00 0.08 27.50 884.08 1.08870238
|
|
35.00 0.09 27.50 994.23 0.96808586
|
|
35.00 0.10 27.50 1104.40 0.87151394
|
|
36.00 0.00 27.50 0.00 NULL
|
|
36.00 0.01 27.50 110.35 8.97145446
|
|
36.00 0.02 27.50 217.48 4.55214273
|
|
36.00 0.03 27.50 330.87 2.99211171
|
|
36.00 0.04 27.50 440.88 2.24550898
|
|
36.00 0.05 27.50 544.25 1.81901700
|
|
36.00 0.06 27.50 654.84 1.51181968
|
|
36.00 0.07 27.50 761.74 1.29965605
|
|
36.00 0.08 27.50 869.36 1.13876875
|
|
36.00 0.09 27.50 986.85 1.00319197
|
|
36.00 0.10 27.50 1101.20 0.89901925
|
|
37.00 0.00 27.50 0.00 NULL
|
|
37.00 0.01 27.50 108.99 9.33571887
|
|
37.00 0.02 27.50 216.92 4.69066937
|
|
37.00 0.03 27.50 328.44 3.09797832
|
|
37.00 0.04 27.50 427.44 2.38045106
|
|
37.00 0.05 27.50 552.00 1.84329710
|
|
37.00 0.06 27.50 658.68 1.54475618
|
|
37.00 0.07 27.50 759.64 1.33945027
|
|
37.00 0.08 27.50 884.00 1.15101810
|
|
37.00 0.09 27.50 989.82 1.02796468
|
|
37.00 0.10 27.50 1095.70 0.92863010
|
|
38.00 0.00 27.50 0.00 NULL
|
|
38.00 0.01 27.50 110.05 9.49568378
|
|
38.00 0.02 27.50 222.34 4.70000900
|
|
38.00 0.03 27.50 324.30 3.22232501
|
|
38.00 0.04 27.50 432.24 2.41763835
|
|
38.00 0.05 27.50 558.85 1.86991143
|
|
38.00 0.06 27.50 659.82 1.58376527
|
|
38.00 0.07 27.50 754.81 1.38445437
|
|
38.00 0.08 27.50 865.60 1.20725508
|
|
38.00 0.09 27.50 972.27 1.07480432
|
|
38.00 0.10 27.50 1098.40 0.95138383
|
|
39.00 0.00 27.50 0.00 NULL
|
|
39.00 0.01 27.50 109.31 9.81154515
|
|
39.00 0.02 27.50 216.08 4.96343947
|
|
39.00 0.03 27.50 327.66 3.27321003
|
|
39.00 0.04 27.50 430.80 2.48955432
|
|
39.00 0.05 27.50 550.30 1.94893694
|
|
39.00 0.06 27.50 659.10 1.62721893
|
|
39.00 0.07 27.50 767.83 1.39679356
|
|
39.00 0.08 27.50 877.76 1.22186019
|
|
39.00 0.09 27.50 986.67 1.08698957
|
|
39.00 0.10 27.50 1080.80 0.99232050
|
|
40.00 0.00 27.50 0.00 NULL
|
|
40.00 0.01 27.50 109.07 10.08526634
|
|
40.00 0.02 27.50 222.44 4.94515375
|
|
40.00 0.03 27.50 320.46 3.43256569
|
|
40.00 0.04 27.50 441.24 2.49297435
|
|
40.00 0.05 27.50 552.70 1.99022978
|
|
40.00 0.06 27.50 653.88 1.68226586
|
|
40.00 0.07 27.50 763.07 1.44154534
|
|
40.00 0.08 27.50 857.12 1.28336756
|
|
40.00 0.09 27.50 976.23 1.12678365
|
|
40.00 0.10 27.50 1086.10 1.01279808
|
|
41.00 0.00 27.50 0.00 NULL
|
|
41.00 0.01 27.50 107.86 10.45336547
|
|
41.00 0.02 27.50 219.46 5.13761050
|
|
41.00 0.03 27.50 331.80 3.39813140
|
|
41.00 0.04 27.50 447.72 2.51831502
|
|
41.00 0.05 27.50 544.20 2.07184859
|
|
41.00 0.06 27.50 643.86 1.75115708
|
|
41.00 0.07 27.50 767.55 1.46895968
|
|
41.00 0.08 27.50 878.00 1.28416856
|
|
41.00 0.09 27.50 975.33 1.15601899
|
|
41.00 0.10 27.50 1104.90 1.02045434
|
|
42.00 0.00 27.50 0.00 NULL
|
|
42.00 0.01 27.50 110.62 10.44114988
|
|
42.00 0.02 27.50 219.04 5.27300950
|
|
42.00 0.03 27.50 331.05 3.48889896
|
|
42.00 0.04 27.50 435.20 2.65395221
|
|
42.00 0.05 27.50 555.90 2.07771182
|
|
42.00 0.06 27.50 649.62 1.77796250
|
|
42.00 0.07 27.50 757.26 1.52523572
|
|
42.00 0.08 27.50 865.52 1.33445790
|
|
42.00 0.09 27.50 982.17 1.17596750
|
|
42.00 0.10 27.50 1103.60 1.04657485
|
|
43.00 0.00 27.50 0.00 NULL
|
|
43.00 0.01 27.50 110.15 10.73536087
|
|
43.00 0.02 27.50 216.90 5.45182112
|
|
43.00 0.03 27.50 330.75 3.57520786
|
|
43.00 0.04 27.50 432.04 2.73701509
|
|
43.00 0.05 27.50 542.50 2.17972350
|
|
43.00 0.06 27.50 656.22 1.80198714
|
|
43.00 0.07 27.50 764.82 1.54611543
|
|
43.00 0.08 27.50 879.44 1.34460566
|
|
43.00 0.09 27.50 976.05 1.21151580
|
|
43.00 0.10 27.50 1071.70 1.10338714
|
|
44.00 0.00 27.50 0.00 NULL
|
|
44.00 0.01 27.50 107.09 11.29890746
|
|
44.00 0.02 27.50 219.96 5.50100018
|
|
44.00 0.03 27.50 330.93 3.65636237
|
|
44.00 0.04 27.50 438.16 2.76154829
|
|
44.00 0.05 27.50 546.35 2.21469754
|
|
44.00 0.06 27.50 651.42 1.85748058
|
|
44.00 0.07 27.50 760.55 1.59095391
|
|
44.00 0.08 27.50 883.20 1.37001812
|
|
44.00 0.09 27.50 970.47 1.24681855
|
|
44.00 0.10 27.50 1090.80 1.10927759
|
|
45.00 0.00 27.50 0.00 NULL
|
|
45.00 0.01 27.50 107.81 11.47852704
|
|
45.00 0.02 27.50 215.26 5.74886184
|
|
45.00 0.03 27.50 323.04 3.83079495
|
|
45.00 0.04 27.50 431.24 2.86963176
|
|
45.00 0.05 27.50 545.15 2.27001743
|
|
45.00 0.06 27.50 662.70 1.86736080
|
|
45.00 0.07 27.50 774.62 1.59755751
|
|
45.00 0.08 27.50 873.76 1.41629280
|
|
45.00 0.09 27.50 974.79 1.26950420
|
|
45.00 0.10 27.50 1077.80 1.14817220
|
|
46.00 0.00 27.50 0.00 NULL
|
|
46.00 0.01 27.50 111.14 11.38204067
|
|
46.00 0.02 27.50 219.06 5.77467361
|
|
46.00 0.03 27.50 324.39 3.89962699
|
|
46.00 0.04 27.50 434.24 2.91313559
|
|
46.00 0.05 27.50 548.20 2.30755199
|
|
46.00 0.06 27.50 651.66 1.94119633
|
|
46.00 0.07 27.50 762.02 1.66006142
|
|
46.00 0.08 27.50 873.04 1.44895996
|
|
46.00 0.09 27.50 1000.62 1.26421619
|
|
46.00 0.10 27.50 1095.90 1.15430240
|
|
47.00 0.00 27.50 0.00 NULL
|
|
47.00 0.01 27.50 110.14 11.73506446
|
|
47.00 0.02 27.50 218.88 5.90506213
|
|
47.00 0.03 27.50 324.39 3.98440149
|
|
47.00 0.04 27.50 441.20 2.92951043
|
|
47.00 0.05 27.50 550.30 2.34871888
|
|
47.00 0.06 27.50 648.66 1.99256930
|
|
47.00 0.07 27.50 779.03 1.65911454
|
|
47.00 0.08 27.50 858.96 1.50472665
|
|
47.00 0.09 27.50 976.77 1.32323884
|
|
47.00 0.10 27.50 1086.60 1.18949015
|
|
48.00 0.00 27.50 0.00 NULL
|
|
48.00 0.01 27.50 109.79 12.02295291
|
|
48.00 0.02 27.50 219.06 6.02574637
|
|
48.00 0.03 27.50 327.84 4.02635432
|
|
48.00 0.04 27.50 435.40 3.03169499
|
|
48.00 0.05 27.50 549.60 2.40174672
|
|
48.00 0.06 27.50 660.66 1.99800200
|
|
48.00 0.07 27.50 765.80 1.72368765
|
|
48.00 0.08 27.50 857.60 1.53917910
|
|
48.00 0.09 27.50 978.39 1.34915524
|
|
48.00 0.10 27.50 1103.80 1.19586882
|
|
49.00 0.00 27.50 0.00 NULL
|
|
49.00 0.01 27.50 109.07 12.35445127
|
|
49.00 0.02 27.50 214.12 6.29320007
|
|
49.00 0.03 27.50 330.54 4.07666243
|
|
49.00 0.04 27.50 436.76 3.08521843
|
|
49.00 0.05 27.50 540.30 2.49398482
|
|
49.00 0.06 27.50 662.94 2.03261230
|
|
49.00 0.07 27.50 760.20 1.77255985
|
|
49.00 0.08 27.50 860.32 1.56627766
|
|
49.00 0.09 27.50 983.43 1.37020429
|
|
49.00 0.10 27.50 1082.10 1.24526384
|
|
50.00 0.00 27.50 0.00 NULL
|
|
50.00 0.01 27.50 106.88 12.86489521
|
|
50.00 0.02 27.50 221.10 6.21890547
|
|
50.00 0.03 27.50 327.66 4.19642312
|
|
50.00 0.04 27.50 431.00 3.19025522
|
|
50.00 0.05 27.50 541.40 2.53971186
|
|
50.00 0.06 27.50 644.04 2.13496056
|
|
50.00 0.07 27.50 767.48 1.79157763
|
|
50.00 0.08 27.50 861.36 1.59631281
|
|
50.00 0.09 27.50 994.86 1.38210401
|
|
50.00 0.10 27.50 1093.50 1.25743027
|