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 78757.60 1
2 41207.20 0.09090909090909091
3 49476.70 0.18181818181818182
4 55699.39 0.45454545454545453
5 62642.70 0.5454545454545454
6 39088.00 0
7 64663.83 0.6363636363636364
8 49981.69 0.2727272727272727
9 68093.57 0.7272727272727273
10 70328.50 0.8181818181818182
11 53999.51 0.36363636363636365
12 77476.26 0.9090909090909091
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