SQL Editor

SQL Cumedist Example

Task:

Calculate the cumulative distribution of the product prices.
Click here for details on CUME_DIST.
 
 78 Records
ProductName UnitPrice Price Distribution
Geitost 2.50 0.01282051282051282
Guaraná Fantástica 4.50 0.02564102564102564
Konbu 6.00 0.038461538461538464
Filo Mix 7.00 0.05128205128205128
Tourtière 7.45 0.0641025641025641
Rhönbräu Klosterbier 7.75 0.07692307692307693
Tunnbröd 9.00 0.08974358974358974
Teatime Chocolate Biscuits 9.20 0.10256410256410256
Zaanse koeken 9.50 0.1282051282051282
Rogede sild 9.50 0.1282051282051282
Jack's New England Clam Chowder 9.65 0.14102564102564102
Stroopwafels 9.75 0.15384615384615385
Longlife Tofu 10.00 0.19230769230769232
Sir Rodney's Scones 10.00 0.19230769230769232
Aniseed Syrup 10.00 0.19230769230769232
Spegesild 12.00 0.20512820512820512
Scottish Longbreads 12.50 0.23076923076923078
Gorgonzola Telino 12.50 0.23076923076923078
Chocolade 12.75 0.24358974358974358
Original Frankfurter grüne Soße 13.00 0.2564102564102564
Escargots de Bourgogne 13.25 0.2692307692307692
Laughing Lumberjack Lager 14.00 0.32051282051282054
Singaporean Hokkien Fried Mee 14.00 0.32051282051282054
Sasquatch Ale 14.00 0.32051282051282054
NuNuCa Nuß-Nougat-Creme 14.00 0.32051282051282054
Röd Kaviar 15.00 0.34615384615384615
Outback Lager 15.00 0.34615384615384615
Genen Shouyu 15.50 0.358974358974359
Valkoinen suklaa 16.25 0.3717948717948718
Louisiana Hot Spiced Okra 17.00 0.38461538461538464
Pavlova 17.45 0.3974358974358974
Chai 18.00 0.44871794871794873
Steeleye Stout 18.00 0.44871794871794873
Chartreuse verte 18.00 0.44871794871794873
Lakkalikööri 18.00 0.44871794871794873
Boston Crab Meat 18.40 0.46153846153846156
Inlagd Sill 19.00 0.48717948717948717
Chang 19.00 0.48717948717948717
Gula Malacca 19.45 0.5
Ravioli Angelo 19.50 0.5128205128205128
Maxilaku 20.00 0.5256410256410257
Queso Cabrales 21.00 0.5512820512820513
Gustaf's Knäckebröd 21.00 0.5512820512820513
Louisiana Fiery Hot Pepper Sauce 21.05 0.5641025641025641
Chef Anton's Gumbo Mix 21.35 0.5769230769230769
Flotemysost 21.50 0.5897435897435898
Chef Anton's Cajun Seasoning 22.00 0.6025641025641025
Tofu 23.25 0.6153846153846154
Pâté chinois 24.00 0.6282051282051282
Grandma's Boysenberry Spread 25.00 0.6410256410256411
Nord-Ost Matjeshering 25.89 0.6538461538461539
Gravad lax 26.00 0.6666666666666666
Sirop d'érable 28.50 0.6794871794871795
Uncle Bob's Organic Dried Pears 30.00 0.6923076923076923
Ikura 31.00 0.7051282051282052
Gumbär Gummibärchen 31.23 0.717948717948718
Mascarpone Fabioli 32.00 0.7307692307692307
Perth Pasties 32.80 0.7435897435897436
Wimmers gute Semmelknödel 33.25 0.7564102564102564
Camembert Pierrot 34.00 0.7692307692307693
Mozzarella di Giovanni 34.80 0.782051282051282
Gudbrandsdalsost 36.00 0.7948717948717948
Gnocchi di nonna Alice 38.00 0.8205128205128205
Queso Manchego La Pastora 38.00 0.8205128205128205
Alice Mutton 39.00 0.8333333333333334
Northwoods Cranberry Sauce 40.00 0.8461538461538461
Schoggi Schokolade 43.90 0.8717948717948718
Vegie-spread 43.90 0.8717948717948718
Rössle Sauerkraut 45.60 0.8846153846153846
Ipoh Coffee 46.00 0.8974358974358975
Tarte au sucre 49.30 0.9102564102564102
Manjimup Dried Apples 53.00 0.9230769230769231
Raclette Courdavault 55.00 0.9358974358974359
Carnarvon Tigers 62.50 0.9487179487179487
Sir Rodney's Marmalade 81.00 0.9615384615384616
Mishi Kobe Niku 97.00 0.9743589743589743
Thüringer Rostbratwurst 123.79 0.9871794871794872
Côte de Blaye 263.50 1
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Cookies       Do Not Sell       Licensing      
Made with    in Austin, Texas.  - vsn 44.0.0
© Data & Object Factory, LLC.