Access_Chapter_4_-_Lab_Test_A_-_GetItNow_Electronics.accdb
| Address | City | State | Zip | Outlet ID |
| 1298 Western Court | Bedlam | CA | 34896 | GINE 11 |
| 25 Parkington Palace | Southtown | CA | 39746 | GINE 15 |
| 1212 Mocking Bird | Ambervson | CA | 38957 | GINE 17 |
| 774 Oakland | Parkville | CA | 38974 | GINE 26 |
| Full Name | Gender | Age | Hire Date | Quota | YTD Sales | Sales Rep ID | Job Type | Outlet ID |
| Smith, Mike | M | 35 | 6/27/12 | ¤ 1,500,000.00 | ¤ 0.00 | 651 | PT | GINE 17 |
| Moeller, Pierre | M | 24 | 3/12/01 | ¤ 3,656,640.00 | ¤ 3,336,300.00 | 321 | PT | GINE 11 |
| Battistini, Jorge | M | 26 | 7/2/01 | ¤ 3,371,092.00 | ¤ 1,960,932.00 | 101 | ST | GINE 15 |
| Lambert, Paul | M | 35 | 3/16/02 | ¤ 1,768,442.00 | ¤ 1,525,237.00 | 205 | PT | GINE 11 |
| Brunell, Candace | F | 36 | 6/1/02 | ¤ 3,000,264.00 | ¤ 2,078,386.00 | 613 | PT | GINE 17 |
| Leon, Tommy | M | 39 | 6/6/02 | ¤ 1,652,836.00 | ¤ 1,432,701.00 | 475 | PT | GINE 26 |
| Lyon, Jody | F | 27 | 8/3/02 | ¤ 2,280,900.00 | ¤ 1,548,311.00 | 125 | FT | GINE 15 |
| Lopez, Maria | F | 25 | 6/3/04 | ¤ 1,837,213.00 | ¤ 1,563,140.00 | 140 | PT | GINE 17 |
| Dillig, Henry | M | 42 | 11/21/06 | ¤ 3,899,402.00 | ¤ 1,916,753.00 | 285 | PT | GINE 11 |
| Kahn, Ramesh | M | 44 | 4/6/07 | ¤ 3,426,535.00 | ¤ 3,292,270.00 | 512 | FT | GINE 26 |
| Chiu, Leslie | F | 36 | 7/15/07 | ¤ 3,218,514.00 | ¤ 2,514,181.00 | 678 | FT | GINE 26 |
| Wochos, Lisa | F | 30 | 10/21/07 | ¤ 2,648,883.00 | ¤ 2,188,106.00 | 287 | ST | GINE 15 |
| Cataldo, Lydia | F | 25 | 11/15/07 | ¤ 3,668,028.00 | ¤ 2,846,910.00 | 465 | FT | GINE 11 |
SELECT DISTINCTROW *
FROM [Sales Rep];
dhurba9212
