| SaleID | CustomerID | EmployeeID | SaleDate | SubTotal | Tax | Total | |
|---|---|---|---|---|---|---|---|
| 1 | 1 | 1 | 1 | 2013-12-14 | 3500.00 | 290.50 | 3790.50 |
| 2 | 2 | 2 | 1 | 2013-12-15 | 1000.00 | 83.00 | 1083.00 |
| 3 | 3 | 3 | 1 | 2013-12-15 | 50.00 | 4.15 | 54.15 |
| 4 | 4 | 4 | 3 | 2013-12-23 | 45.00 | 3.74 | 48.74 |
| 5 | 5 | 1 | 5 | 2014-01-05 | 250.00 | 20.75 | 270.75 |
| 6 | 6 | 5 | 5 | 2014-01-10 | 750.00 | 62.25 | 812.25 |
| 7 | 7 | 6 | 4 | 2014-01-12 | 250.00 | 20.75 | 270.75 |
| 8 | 8 | 2 | 1 | 2014-01-15 | 3000.00 | 249.00 | 3249.00 |
| 9 | 9 | 5 | 5 | 2014-01-25 | 350.00 | 29.05 | 379.05 |
| 10 | 10 | 7 | 1 | 2014-02-04 | 14250.00 | 1182.75 | 15432.75 |
| 11 | 11 | 8 | 5 | 2014-02-04 | 250.00 | 20.75 | 270.75 |
| 12 | 12 | 5 | 4 | 2014-02-07 | 50.00 | 4.15 | 54.15 |
| 13 | 13 | 9 | 2 | 2014-02-07 | 4500.00 | 373.50 | 4873.50 |
| 14 | 14 | 10 | 3 | 2014-02-11 | 3675.00 | 305.03 | 3980.03 |
| 15 | 15 | 2 | 2 | 2014-02-11 | 800.00 | 66.40 | 866.40 |
| EmployeeID | LastName | FirstName | Phone | ||
|---|---|---|---|---|---|
| 1 | 1 | Stuart | Anne | 206-527-0010 | Anne.Stuart@QACS.com |
| 2 | 2 | Stuart | George | 206-527-0011 | George.Stuart@QACS.com |
| 3 | 3 | Stuart | Mary | 206-527-0012 | Mary.Stuart@QACS.com |
| 4 | 4 | Orange | William | 206-527-0013 | William.Orange@QACS.com |
| 5 | 5 | Griffith | John | 206-527-0014 | John.Griffith@QACS.com |
| SaleID | SaleItemID | ItemID | ItemPrice | |
|---|---|---|---|---|
| 1 | 1 | 1 | 1 | 3000.00 |
| 2 | 1 | 2 | 2 | 500.00 |
| 3 | 1 | 3 | 8 | 10.00 |
| 4 | 2 | 1 | 3 | 1000.00 |
| 5 | 3 | 1 | 4 | 50.00 |
| 6 | 4 | 1 | 5 | 45.00 |
| 7 | 5 | 1 | 6 | 250.00 |
| 8 | 6 | 1 | 7 | 750.00 |
| 9 | 7 | 1 | 8 | 250.00 |
| 10 | 8 | 1 | 9 | 1250.00 |
| 11 | 8 | 2 | 10 | 1750.00 |
| 12 | 9 | 1 | 11 | 350.00 |
| 13 | 10 | 1 | 19 | 5000.00 |
| 14 | 10 | 2 | 21 | 8500.00 |
| 15 | 10 | 3 | 22 | 750.00 |
| 16 | 11 | 1 | 17 | 250.00 |
| 17 | 12 | 1 | 24 | 50.00 |
| 18 | 13 | 1 | 20 | 4500.00 |
| 19 | 14 | 1 | 12 | 3200.00 |
| 20 | 14 | 2 | 14 | 475.00 |
| 21 | 15 | 1 | 23 | 800.00 |
| CustomerID | LastName | FirstName | Address | City | State | ZIP | Phone | ||
|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | Shire | Robert | 6225 Evanston Ave N | Seattle | WA | 98103 | 206-524-2433 | Robert.Shire@somewhere.com |
| 2 | 2 | Goodyear | Katherine | 7335 11th Ave NE | Seattle | WA | 98105 | 206-524-3544 | Katherine.Goodyear@somewhere.com |
| 3 | 3 | Bancroft | Chris | 12605 NE 6th Street | Bellevue | WA | 98005 | 425-635-9788 | Chris.Bancroft@somewhere.com |
| 4 | 4 | Griffith | John | 335 Aloha Street | Seattle | WA | 98109 | 206-524-4655 | John.Griffith@somewhere.com |
| 5 | 5 | Tierney | Doris | 14510 NE 4th Street | Bellevue | WA | 98005 | 425-635-8677 | Doris.Tierney@somewhere.com |
| 6 | 6 | Anderson | Donna | 1410 Hillcrest Parkway | Mt. Vernon | WA | 98273 | 360-538-7566 | Donna.Anderson@elsewhere.com |
| 7 | 7 | Svane | Jack | 3211 42nd Street | Seattle | WA | 98115 | 206-524-5766 | Jack.Svane@somewhere.com |
| 8 | 8 | Walsh | Denesha | 6712 24th Avenue NE | Redmond | WA | 98053 | 425-635-7566 | Denesha.Walsh@somewhere.com |
| 9 | 9 | Enquist | Craig | 534 15th Street | Bellingham | WA | 98225 | 360-538-6455 | Craig.Enquist@elsewhere.com |
| 10 | 10 | Anderson | Rose | 6823 17th Ave NE | Seattle | WA | 98105 | 206-524-6877 | Rose.Anderson@elsewhere.com |