Team Assignment – Paige Phillips, Mark Webb
Bus 140-006 R. McLeish
1. Which are the best performing sales regions by Total Sales? Query1 | Sales Region | Total Sales | East | $529,124.80 | South | $234,595.05 | North | $233,832.75 |
2. Which are the best performing stores by Total Sales? Query2 | Store No | Total Sales | 6 | $267,648.90 | 7 | $170,040.85 | 5 | $158,334.00 | 8 | $91,435.05 | 1 | $90,281.10 | 3 | $90,051.25 | 4 | $75,498.75 | 2 | $54,262.70 |
3. What are the best-selling products by Total Sales?
Query1 | Item Description | Total Sales | Desktop CPU | $833,800.95 | 17" Monitor | $139,461.00 | 101 Keyboard | $18,294.15 | PC Mouse | $5,996.50 |
4. Which are the best performing sales regions by Units Sold?
Query1 | Sales Region | SumOfUnits Sold | East | 1532 | North | 882 | South | 763 |
5. Which are the best performing stores by Units Sold?
Query1 | Store No | SumOfUnits Sold | 6 | 727 | 5 | 615 | 7 | 548 | 1 | 325 | 3 | 306 | 4 | 267 | 8 | 257 | 2 | 132 |
6. What are the best-selling products by Units Sold?
Query1 | Item Description | SumOfUnits Sold | Desktop CPU | 981 | 101 Keyboard | 917 | PC Mouse | 670 | 17" Monitor | 609 |
7. Which are the best performing sales regions by Weekly Sales? (Sort by weeks, then by total sales)
Query1 | Sales Region | Week Ending | Total Sales | East | 12/29/2006 | $186,218.55 | East | 11/24/2006 | $181,965.35 | East | 10/27/2006 | $160,940.90 | North | 11/24/2006 | $81,578.90 | South | 10/27/2006 | $79,203.95 | South | 11/24/2006 | $78,416.80 | North | 10/27/2006 | $77,577.90 | South | 12/29/2006 | $76,974.30 | North | 12/29/2006 | $74,675.95 |
8. What are the best-selling products by Weekly Sales? (Sort by weeks, then by total sales)
Query1 | Item Description | Week Ending | Total Sales | Desktop