SQL Editor

Tables and Columns 

Task:

List the monthly sales for the year 2013. Include the percentage rank values for each month sorted by month.
Click here for details on PERCENT_RANK.
 
 12 Records
Month Monthly Sales Sales Distribution
1 69409.60 0.8181818181818182
2 41207.20 0.18181818181818182
3 39979.90 0.09090909090909091
4 55699.39 0.5454545454545454
5 56823.70 0.6363636363636364
6 39088.00 0
7 55464.93 0.45454545454545453
8 49981.69 0.36363636363636365
9 59733.02 0.7272727272727273
10 70328.50 0.9090909090909091
11 45913.36 0.2727272727272727
12 77476.26 1
Products
Pricing
Demos
Tutorials
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