SQL Editor

Tables and Columns 

Task:

List the monthly sales for the year 2013. For each month, include the sales from 6 months ago.
Click here for details on LAG.
 
 12 Records
Month Monthly Sales 6 Months ago
1 69409.60 NULL
2 41207.20 NULL
3 39979.90 NULL
4 55699.39 NULL
5 56823.70 NULL
6 39088.00 NULL
7 55464.93 69409.60
8 49981.69 41207.20
9 59733.02 39979.90
10 70328.50 55699.39
11 45913.36 56823.70
12 77476.26 39088.00
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