Query
on T-SQL window clause
Below is the sales table
|
Order_Date |
Name |
Product |
SubCategory |
Category |
Quantity |
SalesAmount |
DiscountAmount |
|
10-08-2011 |
Megan Stewart |
Mountain-100 Silver, 38 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
|
14-09-2011 |
Elizabeth Clark |
Mountain-100 Silver, 38 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
|
14-10-2011 |
Olivia Torres |
Mountain-100 Silver, 38 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
|
20-10-2011 |
Ethan Foster |
Mountain-100 Silver, 38 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
|
14-11-2011 |
Beth Gutierrez |
Mountain-100 Silver, 38 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
|
14-11-2011 |
Dawn Wu |
Mountain-100 Silver, 38 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
|
20-12-2011 |
Desiree Dominguez |
Mountain-100 Silver, 38 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
|
22-12-2011 |
Kevin Wright |
Mountain-100 Silver, 38 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
|
17-01-2011 |
Clarence Rai |
Mountain-100 Silver, 42 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
|
23-01-2011 |
Elizabeth Johnson |
Mountain-100 Silver, 42 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
|
03-02-2011 |
Jaclyn Lu |
Mountain-100 Silver, 42 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
|
19-03-2011 |
Jon Zhou |
Mountain-100 Silver, 42 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
|
04-04-2011 |
Arthur Carlson |
Mountain-100 Silver, 42 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
|
07-04-2011 |
Adam Ross |
Mountain-100 Silver, 42 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
|
17-04-2011 |
Carolyn Navarro |
Mountain-100 Silver, 42 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
|
29-04-2011 |
Abby Sai |
Mountain-100 Silver, 42 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
|
05-05-2011 |
Ross Jordan |
Mountain-100 Silver, 42 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
|
06-05-2011 |
April Deng |
Mountain-100 Silver, 42 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
|
02-06-2011 |
Ebony Gutierrez |
Mountain-100 Silver, 42 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
|
08-06-2011 |
Julian Ross |
Mountain-100 Silver, 42 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
- From the above table display all records along with sum of sales amount for each category.
- From the above table display all the records along with sales amount per month.
- Compare the sales between each day with previous sales value for each category.
