Problem:

List the orders for the year 2013. Include the percentage rank of the order amounts within each month sorted by amount.
Click here for details on PERCENT_RANK.
 
 408 Records
Month Customer TotalAmount Percent Rank
1 Paolo Accorti 49.80 0
1 Yoshi Latimer 102.40 0.03125
1 Maurizio Moroni 192.00 0.0625
1 Aria Cruz 231.40 0.09375
1 Yvonne Moncada 319.20 0.125
1 Eduardo Saavedra 338.20 0.15625
1 Pirkko Koskitalo 372.00 0.1875
1 Felipe Izquierdo 400.00 0.21875
1 Annette Roulet 480.00 0.25
1 Art Braunschweiger 485.00 0.28125
1 Georg Pipps 651.00 0.3125
1 Pirkko Koskitalo 720.00 0.34375
1 Elizabeth Lincoln 802.00 0.375
1 Roland Mendel 1005.90 0.40625
1 André Fonseca 1020.00 0.4375
1 Henriette Pfalzheim 1194.00 0.46875
1 Elizabeth Lincoln 1208.50 0.5
1 Bernardo Batista 1273.20 0.53125
1 Martine Rancé 1622.40 0.5625
1 Giovanni Rovelli 1675.00 0.59375
1 Patricia McKenna 1748.50 0.625
1 Horst Kloss 1814.80 0.65625
1 Paula Parente 1897.60 0.6875
1 Lúcia Carvalho 2018.20 0.71875
1 Annette Roulet 2123.20 0.75
1 Michael Holz 2208.00 0.78125
1 Elizabeth Lincoln 2523.00 0.8125
1 Roland Mendel 2713.50 0.84375
1 Ann Devon 3063.00 0.875
1 Paula Wilson 3868.60 0.90625
1 Roland Mendel 5796.00 0.9375
1 Jytte Petersen 11283.20 0.96875
1 Jean Fresnière 11493.20 1
2 Christina Berglund 174.90 0
2 Maria Larsson 234.80 0.03571428571428571
2 Karin Josephs 273.60 0.07142857142857142
2 Maria Larsson 360.00 0.10714285714285714
2 Pirkko Koskitalo 393.00 0.14285714285714285
2 Annette Roulet 414.00 0.17857142857142858
2 Sergio Gutiérrez 443.40 0.21428571428571427
2 Thomas Hardy 453.00 0.25
2 Mary Saveley 531.40 0.2857142857142857
2 Maurizio Moroni 537.60 0.32142857142857145
2 Karin Josephs 567.50 0.35714285714285715
2 Elizabeth Brown 631.60 0.39285714285714285
2 Philip Cramer 656.00 0.42857142857142855
2 Isabel de Castro 851.20 0.4642857142857143
2 Janete Limeira 914.40 0.5
2 Christina Berglund 1031.70 0.5357142857142857
2 Jean Fresnière 1078.00 0.5714285714285714
2 Philip Cramer 1584.00 0.6071428571428571
2 Mary Saveley 1688.00 0.6428571428571429
2 Rene Phillips 1755.00 0.6785714285714286
2 Roland Mendel 1792.00 0.7142857142857143
2 Frédérique Citeaux 1838.20 0.75
2 Carlos González 2051.60 0.7857142857142857
2 Jose Pavarotti 2096.00 0.8214285714285714
2 Frédérique Citeaux 2210.80 0.8571428571428571
2 Pirkko Koskitalo 2684.00 0.8928571428571429
2 Pascale Cartrain 3891.00 0.9285714285714286
2 Horst Kloss 4277.40 0.9642857142857143
2 Jose Pavarotti 5793.10 1
3 John Steel 147.00 0
3 Elizabeth Brown 156.00 0.034482758620689655
3 Carlos Hernández 182.40 0.06896551724137931
3 Pedro Afonso 216.00 0.10344827586206896
3 Helen Bennett 230.40 0.13793103448275862
3 Giovanni Rovelli 235.20 0.1724137931034483
3 Lino Rodriguez 305.30 0.20689655172413793
3 Victoria Ashworth 386.20 0.2413793103448276
3 Mary Saveley 496.00 0.27586206896551724
3 Georg Pipps 502.20 0.3103448275862069
3 Isabel de Castro 672.00 0.3448275862068966
3 Karl Jablonski 704.00 0.3793103448275862
3 Pascale Cartrain 713.30 0.41379310344827586
3 Philip Cramer 717.60 0.4482758620689655
3 Martine Rancé 756.00 0.4827586206896552
3 Lúcia Carvalho 925.10 0.5172413793103449
3 Hari Kumar 1051.20 0.5517241379310345
3 Karl Jablonski 1125.50 0.5862068965517241
3 Guillermo Fernández 1249.10 0.6206896551724138
3 Carlos Hernández 1272.00 0.6551724137931034
3 Victoria Ashworth 1328.00 0.6896551724137931
3 Janete Limeira 1472.00 0.7241379310344828
3 Peter Franken 1560.00 0.7586206896551724
3 Felipe Izquierdo 1760.00 0.7931034482758621
3 Pascale Cartrain 1770.80 0.8275862068965517
3 Laurence Lebihan 1820.80 0.8620689655172413
3 Lino Rodriguez 1848.00 0.896551724137931
3 Palle Ibsen 2719.00 0.9310344827586207
3 Carlos Hernández 3163.20 0.9655172413793104
3 Paula Wilson 10495.60 1
4 Hanna Moos 136.80 0
4 Jean Fresnière 147.90 0.03333333333333333
4 Hanna Moos 149.00 0.06666666666666667
4 Jonas Bergulfsen 200.00 0.1
4 Anabela Domingues 200.00 0.1
4 Patricio Simpson 225.50 0.16666666666666666
4 Henriette Pfalzheim 240.00 0.2
4 Yoshi Tannamuri 278.00 0.23333333333333334
4 Simon Crowther 352.00 0.26666666666666666
4 Philip Cramer 462.00 0.3
4 Annette Roulet 550.80 0.3333333333333333
4 Carlos Hernández 575.00 0.36666666666666664
4 Aria Cruz 618.00 0.4
4 Annette Roulet 676.00 0.43333333333333335
4 Guillermo Fernández 816.30 0.4666666666666667
4 Antonio Moreno 881.25 0.5
4 Elizabeth Lincoln 896.00 0.5333333333333333
4 Pedro Afonso 912.00 0.5666666666666667
4 Renate Messner 1380.60 0.6
4 Karl Jablonski 1388.50 0.6333333333333333
4 Carlos González 1412.00 0.6666666666666666
4 Patricia McKenna 2048.50 0.7
4 Yang Wang 2356.00 0.7333333333333333
4 Rita Müller 2427.50 0.7666666666666667
4 Patricia McKenna 2614.50 0.8
4 Renate Messner 2657.80 0.8333333333333334
4 Laurence Lebihan 3000.00 0.8666666666666667
4 Miguel Angel Paolino 4150.05 0.9
4 Jose Pavarotti 4735.44 0.9333333333333333
4 Roland Mendel 8623.45 0.9666666666666667
4 Horst Kloss 10588.50 1
5 Yvonne Moncada 110.00 0
5 Victoria Ashworth 139.80 0.03225806451612903
5 John Steel 210.00 0.06451612903225806
5 Karin Josephs 275.10 0.0967741935483871
5 Victoria Ashworth 355.50 0.12903225806451613
5 Howard Snyder 396.20 0.16129032258064516
5 Fran Wilson 417.20 0.1935483870967742
5 Philip Cramer 493.80 0.22580645161290322
5 Renate Messner 517.40 0.25806451612903225
5 José Pedro Freyre 749.00 0.2903225806451613
5 Ann Devon 796.35 0.3225806451612903
5 Laurence Lebihan 846.00 0.3548387096774194
5 Carlos Hernández 880.50 0.3870967741935484
5 Catherine Dewey 946.00 0.41935483870967744
5 Pirkko Koskitalo 1344.00 0.45161290322580644
5 Pirkko Koskitalo 1546.30 0.4838709677419355
5 Horst Kloss 1670.00 0.5161290322580645
5 Carlos González 1770.00 0.5483870967741935
5 Henriette Pfalzheim 1819.50 0.5806451612903226
5 Michael Holz 1823.80 0.6129032258064516
5 Lino Rodriguez 1836.00 0.6451612903225806
5 Hari Kumar 1908.00 0.6774193548387096
5 Renate Messner 2085.00 0.7096774193548387
5 Antonio Moreno 2156.50 0.7419354838709677
5 Mario Pontes 2162.80 0.7741935483870968
5 Maria Larsson 2295.20 0.8064516129032258
5 Hari Kumar 2715.90 0.8387096774193549
5 Mary Saveley 2812.00 0.8709677419354839
5 Christina Berglund 3192.65 0.9032258064516129
5 Georg Pipps 4180.00 0.9354838709677419
5 Horst Kloss 4181.50 0.967741935483871
5 Horst Kloss 10191.70 1
6 Eduardo Saavedra 155.00 0
6 Jaime Yorres 317.75 0.034482758620689655
6 Hanna Moos 330.00 0.06896551724137931
6 Aria Cruz 387.50 0.10344827586206896
6 Victoria Ashworth 477.00 0.13793103448275862
6 Maurizio Moroni 543.00 0.1724137931034483
6 Frédérique Citeaux 547.80 0.20689655172413793
6 Helvetius Nagy 569.00 0.2413793103448276
6 Frédérique Citeaux 625.00 0.27586206896551724
6 Roland Mendel 647.75 0.3103448275862069
6 Jean Fresnière 711.00 0.3448275862068966
6 Helvetius Nagy 764.30 0.3793103448275862
6 Jytte Petersen 835.20 0.41379310344827586
6 Miguel Angel Paolino 838.45 0.4482758620689655
6 Janete Limeira 965.00 0.4827586206896552
6 Paula Wilson 977.50 0.5172413793103449
6 Henriette Pfalzheim 1067.10 0.5517241379310345
6 Renate Messner 1152.50 0.5862068965517241
6 Peter Franken 1257.30 0.6206896551724138
6 Paula Wilson 1299.00 0.6551724137931034
6 Christina Berglund 1565.65 0.6896551724137931
6 Frédérique Citeaux 2040.00 0.7241379310344828
6 Antonio Moreno 2082.00 0.7586206896551724
6 Thomas Hardy 2142.90 0.7931034482758621
6 Alexander Feuer 2147.40 0.8275862068965517
6 Pirkko Koskitalo 2413.90 0.8620689655172413
6 Jean Fresnière 2595.00 0.896551724137931
6 Maria Larsson 2844.50 0.9310344827586207
6 Patricia McKenna 3109.00 0.9655172413793104
6 Jose Pavarotti 3680.50 1
7 Maurizio Moroni 28.00 0
7 Palle Ibsen 65.00 0.03125
7 Howard Snyder 72.00 0.0625
7 Matti Karttunen 120.00 0.09375
7 Paula Parente 142.50 0.125
7 Lino Rodriguez 256.50 0.15625
7 Carlos Hernández 358.00 0.1875
7 Annette Roulet 399.00 0.21875
7 Janine Labrune 424.00 0.25
7 Hanna Moos 464.00 0.28125
7 Yoshi Latimer 479.80 0.3125
7 Victoria Ashworth 493.00 0.34375
7 Renate Messner 543.65 0.375
7 Rene Phillips 565.50 0.40625
7 Georg Pipps 800.10 0.4375
7 Bernardo Batista 807.38 0.46875
7 Zbyszek Piestrzeniewicz 808.00 0.5
7 Palle Ibsen 812.50 0.53125
7 Karin Josephs 1064.00 0.5625
7 Jean Fresnière 1140.00 0.59375
7 Anabela Domingues 1413.00 0.625
7 Karl Jablonski 1476.10 0.65625
7 Jose Pavarotti 1508.00 0.6875
7 Howard Snyder 1650.00 0.71875
7 Carlos Hernández 2285.00 0.75
7 Paula Wilson 2388.50 0.78125
7 Renate Messner 2493.00 0.8125
7 Horst Kloss 3900.00 0.84375
7 Jean Fresnière 4326.00 0.875
7 Howard Snyder 5032.00 0.90625
7 Roland Mendel 6300.00 0.9375
7 Jose Pavarotti 6375.00 0.96875
7 Jose Pavarotti 6475.40 1
8 Yoshi Tannamuri 57.50 0
8 Annette Roulet 62.00 0.03125
8 Janete Limeira 382.50 0.0625
8 Frédérique Citeaux 450.00 0.09375
8 Ana Trujillo 479.75 0.125
8 Jonas Bergulfsen 500.00 0.15625
8 Janete Limeira 605.00 0.1875
8 Rita Müller 620.00 0.21875
8 Pirkko Koskitalo 629.50 0.25
8 Bernardo Batista 636.00 0.28125
8 Helen Bennett 758.50 0.3125
8 Jytte Petersen 870.00 0.34375
8 Philip Cramer 918.00 0.375
8 Rita Müller 945.00 0.40625
8 Maria Anders 1086.00 0.4375
8 Jean Fresnière 1260.00 0.46875
8 Jose Pavarotti 1264.50 0.5
8 Giovanni Rovelli 1380.25 0.53125
8 Liu Wong 1393.24 0.5625
8 Paula Parente 1422.00 0.59375
8 Peter Franken 1429.75 0.625
8 Catherine Dewey 1434.00 0.65625
8 Christina Berglund 1503.60 0.6875
8 Mario Pontes 1535.00 0.71875
8 Aria Cruz 1820.20 0.75
8 Patricia McKenna 1928.00 0.78125
8 Carlos Hernández 2054.00 0.8125
8 Jean Fresnière 2697.50 0.84375
8 Felipe Izquierdo 2720.05 0.875
8 José Pedro Freyre 2775.05 0.90625
8 Lúcia Carvalho 2896.25 0.9375
8 Martine Rancé 4985.50 0.96875
8 Roland Mendel 6483.05 1
9 Helen Bennett 45.00 0
9 Janine Labrune 63.00 0.027777777777777776
9 Fran Wilson 125.00 0.05555555555555555
9 Maurizio Moroni 193.00 0.08333333333333333
9 André Fonseca 331.78 0.1111111111111111
9 Antonio Moreno 375.50 0.1388888888888889
9 Matti Karttunen 412.35 0.16666666666666666
9 Rita Müller 530.40 0.19444444444444445
9 Miguel Angel Paolino 534.85 0.2222222222222222
9 Jytte Petersen 570.00 0.25
9 Frédérique Citeaux 660.00 0.2777777777777778
9 Christina Berglund 668.70 0.3055555555555556
9 Howard Snyder 671.35 0.3333333333333333
9 Rita Müller 694.75 0.3611111111111111
9 Patricia McKenna 703.25 0.3888888888888889
9 André Fonseca 801.10 0.4166666666666667
9 Carine Schmitt 920.10 0.4444444444444444
9 Antonio Moreno 956.90 0.4722222222222222
9 Peter Franken 1203.50 0.5
9 Lúcia Carvalho 1291.60 0.5277777777777778
9 Fran Wilson 1295.00 0.5555555555555556
9 Howard Snyder 1327.00 0.5833333333333334
9 Peter Franken 1423.00 0.6111111111111112
9 Lino Rodriguez 1515.75 0.6388888888888888
9 Georg Pipps 1638.45 0.6666666666666666
9 Rene Phillips 1682.50 0.6944444444444444
9 Yoshi Latimer 1701.00 0.7222222222222222
9 Henriette Pfalzheim 1768.00 0.75
9 Roland Mendel 1921.00 0.7777777777777778
9 Laurence Lebihan 2032.00 0.8055555555555556
9 Peter Franken 2301.75 0.8333333333333334
9 Christina Berglund 4210.50 0.8611111111111112
9 Jose Pavarotti 4371.60 0.8888888888888888
9 Michael Holz 4666.94 0.9166666666666666
9 Horst Kloss 4668.00 0.9444444444444444
9 Jose Pavarotti 5256.50 0.9722222222222222
9 Patricia McKenna 6201.90 1
10 Paolo Accorti 93.50 0
10 Alexander Feuer 114.00 0.02702702702702703
10 Liz Nixon 180.40 0.05405405405405406
10 Aria Cruz 287.80 0.08108108108108109
10 Maria Anders 330.00 0.10810810810810811
10 Carlos Hernández 378.00 0.13513513513513514
10 Karl Jablonski 468.45 0.16216216216216217
10 Bernardo Batista 550.00 0.1891891891891892
10 Lúcia Carvalho 595.50 0.21621621621621623
10 Christina Berglund 630.00 0.24324324324324326
10 Jean Fresnière 638.50 0.2702702702702703
10 Matti Karttunen 642.00 0.2972972972972973
10 Sergio Gutiérrez 706.00 0.32432432432432434
10 Maria Anders 878.00 0.35135135135135137
10 Horst Kloss 972.50 0.3783783783783784
10 Karl Jablonski 996.00 0.40540540540540543
10 Felipe Izquierdo 1073.90 0.43243243243243246
10 Jaime Yorres 1125.67 0.4594594594594595
10 Mario Pontes 1150.00 0.4864864864864865
10 Patricia McKenna 1238.40 0.5135135135135135
10 Laurence Lebihan 1296.00 0.5405405405405406
10 Peter Franken 1331.75 0.5675675675675675
10 Jose Pavarotti 1570.00 0.5945945945945946
10 Thomas Hardy 1704.00 0.6216216216216216
10 Rene Phillips 1893.00 0.6486486486486487
10 Jose Pavarotti 2048.00 0.6756756756756757
10 Karl Jablonski 2334.00 0.7027027027027027
10 Maria Larsson 2545.00 0.7297297297297297
10 Jose Pavarotti 2827.90 0.7567567567567568
10 Jose Pavarotti 2941.00 0.7837837837837838
10 Patricia McKenna 3370.00 0.8108108108108109
10 André Fonseca 3424.00 0.8378378378378378
10 Philip Cramer 3463.00 0.8648648648648649
10 Palle Ibsen 3490.00 0.8918918918918919
10 Roland Mendel 3600.73 0.918918918918919
10 Jose Pavarotti 4451.70 0.9459459459459459
10 Horst Kloss 4825.00 0.972972972972973
10 Horst Kloss 10164.80 1
11 Dominique Perrier 52.35 0
11 Giovanni Rovelli 55.20 0.030303030303030304
11 Paolo Accorti 88.00 0.06060606060606061
11 Paul Henriot 139.80 0.09090909090909091
11 Paul Henriot 240.00 0.12121212121212122
11 Simon Crowther 252.00 0.15151515151515152
11 Thomas Hardy 285.00 0.18181818181818182
11 Ana Trujillo 320.00 0.21212121212121213
11 Thomas Hardy 336.00 0.24242424242424243
11 Laurence Lebihan 360.00 0.2727272727272727
11 Laurence Lebihan 509.75 0.30303030303030304
11 Jaime Yorres 596.00 0.3333333333333333
11 Ann Devon 655.00 0.36363636363636365
11 Palle Ibsen 920.00 0.3939393939393939
11 Patricia McKenna 997.00 0.42424242424242425
11 Helen Bennett 1080.00 0.45454545454545453
11 Lúcia Carvalho 1296.75 0.48484848484848486
11 Christina Berglund 1459.00 0.5151515151515151
11 André Fonseca 1498.35 0.5454545454545454
11 Michael Holz 1644.60 0.5757575757575758
11 Michael Holz 1701.46 0.6060606060606061
11 Maurizio Moroni 1710.00 0.6363636363636364
11 Karl Jablonski 1770.00 0.6666666666666666
11 Felipe Izquierdo 1850.00 0.696969696969697
11 Pirkko Koskitalo 1871.25 0.7272727272727273
11 Georg Pipps 1912.85 0.7575757575757576
11 Yang Wang 1990.00 0.7878787878787878
11 Jose Pavarotti 2196.00 0.8181818181818182
11 Yang Wang 2311.70 0.8484848484848485
11 Art Braunschweiger 2487.50 0.8787878787878788
11 Laurence Lebihan 2598.00 0.9090909090909091
11 Jose Pavarotti 3082.00 0.9393939393939394
11 Elizabeth Lincoln 3118.00 0.9696969696969697
11 Horst Kloss 4529.80 1
12 Patricio Simpson 12.50 0
12 Paolo Accorti 18.40 0.02127659574468085
12 Pascale Cartrain 28.00 0.0425531914893617
12 Christina Berglund 96.50 0.06382978723404255
12 Thomas Hardy 191.10 0.0851063829787234
12 Liu Wong 228.00 0.10638297872340426
12 André Fonseca 280.00 0.1276595744680851
12 Mario Pontes 315.00 0.14893617021276595
12 Roland Mendel 344.00 0.1702127659574468
12 Manuel Pereira 387.50 0.19148936170212766
12 Bernardo Batista 393.45 0.2127659574468085
12 Zbyszek Piestrzeniewicz 399.85 0.23404255319148937
12 Sven Ottlieb 420.00 0.2553191489361702
12 Helen Bennett 446.60 0.2765957446808511
12 Mary Saveley 572.10 0.2978723404255319
12 Martine Rancé 616.00 0.3191489361702128
12 Paula Wilson 629.50 0.3404255319148936
12 Carlos González 720.00 0.3617021276595745
12 Horst Kloss 770.00 0.3829787234042553
12 André Fonseca 850.00 0.40425531914893614
12 Maria Larsson 875.00 0.425531914893617
12 Pirkko Koskitalo 1132.35 0.44680851063829785
12 Paula Parente 1255.80 0.46808510638297873
12 Alexander Feuer 1335.00 0.48936170212765956
12 Mario Pontes 1442.50 0.5106382978723404
12 Thomas Hardy 1477.00 0.5319148936170213
12 Philip Cramer 1585.00 0.5531914893617021
12 Hari Kumar 1632.15 0.574468085106383
12 Giovanni Rovelli 1650.00 0.5957446808510638
12 Horst Kloss 1684.00 0.6170212765957447
12 Palle Ibsen 1704.00 0.6382978723404256
12 Lúcia Carvalho 1913.85 0.6595744680851063
12 Peter Franken 1926.06 0.6808510638297872
12 Roland Mendel 2216.25 0.7021276595744681
12 Hari Kumar 2290.40 0.723404255319149
12 Henriette Pfalzheim 2310.00 0.7446808510638298
12 Roland Mendel 2499.25 0.7659574468085106
12 Roland Mendel 2540.00 0.7872340425531915
12 Annette Roulet 2760.80 0.8085106382978723
12 Liz Nixon 2775.00 0.8297872340425532
12 Carlos Hernández 2878.08 0.851063829787234
12 Catherine Dewey 3304.00 0.8723404255319149
12 Renate Messner 3603.22 0.8936170212765957
12 Martine Rancé 3687.00 0.9148936170212766
12 Jytte Petersen 3923.75 0.9361702127659575
12 Martín Sommer 4035.80 0.9574468085106383
12 Maria Larsson 4337.00 0.9787234042553191
12 Roland Mendel 6984.50 1
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Licensing       EULA       Sitemap      
© Data & Object Factory, LLC.
Made with    in Austin, Texas.      Vsn 1.3.0