Access simple query
Samualadams
HW6UnlimitedPickers.xlsx.xlsxCustomers
| Customer ID | Last Name | First name | Business | Address | City | State | ZipCode | Phone | First Pickup |
| 4 | Rivera | Amy | Riviera's Orchards | Pond Hill Drive | Fairfax | VA | 22030 | (703) 792-3646 | 2/28/2011 |
| 20 | Wagoner | Eliza | Wagoner Farms | 114 Lexington Street | Lubbock | TX | 22957 | (307) 838-7111 | 7/2/2011 |
| 80 | Monarch | James | Monarch Ranch | 482 Weston Ave | Lafayette | LA | 45190 | (775) 815-2456 | 12/28/2010 |
| 65 | Meadows | Max | Meadows Hills | 1935 Snow Ave | Boulder | CO | 58902 | (733) 555-6731 | 05/19/2011 |
| 2 | Smith | Sam | Fairfax Vineyard | 2140 Edgewood Ave | Fairfax | VA | 22030 | (703) 886-6003 | 05/25/2010 |
| 3 | Lake | Sheila | Weiderkehr Farms | 701 Eastman Road | Sterling | AR | 75906 | (701) 562-4499 | 08/25/2010 |
| 85 | Williams | Sara | Green Country Valley Orchard | 230 Southpark Circle | Tulsa | OK | 66911 | (596) 333-0000 | 07/19/2011 |
| 1 | Guo | Alto | Alto's Trees | 5480 Alpine Street | Fairfax | VA | 22030 | (703) 161-5545 | 05/25/2010 |
| 64 | Calahan | Juan | Golden Slopes Vineyard | 431 Phillips Lane | Maryland | MO | 20199 | (410) 352-4847 | 07/17/2011 |
Picking Records
| Customer | Service Date | Grapes | Apples | Grapefruit | Watermelon | Strawberries |
| 20 | 9/15/2012 | 18 | 7 | 7 | 40 | 36 |
| 1 | 10/15/2012 | 32 | 9 | 4 | 85 | 4 |
| 3 | 10/15/2012 | 2983 | 1111 | 413 | 210 | 55 |
| 80 | 10/15/2012 | 150 | 500 | 900 | 2599 | 1200 |
| 1 | 11/7/2012 | 651 | 3 | 8 | 43 | 4 |
| 2 | 11/7/2012 | 19 | 7 | 11 | 0 | 1 |
| 80 | 11/7/2012 | 250 | 555 | 297 | 691 | 0 |
| 1 | 11/22/2012 | 55 | 25 | 7 | 15 | 5 |
| 4 | 3/3/2013 | 350 | 6 | 14 | 17 | 4 |
| 65 | 3/17/2013 | 15 | 190 | 330 | 220 | 111 |
| 3 | 11/22/2012 | 160 | 12 | 18 | 32 | 19 |
| 20 | 10/2/2013 | 14 | 31 | 4 | 60 | 0 |
| 80 | 11/22/2012 | 0 | 25 | 77 | 10 | 40 |
| 4 | 10/15/2012 | 22 | 60 | 22 | 16 | 6 |
| 3 | 12/4/2012 | 113 | 90 | 10 | 12 | 22 |
| 4 | 12/4/2012 | 311 | 14 | 0 | 11 | 1 |
| 65 | 4/2/2013 | 15 | 555 | 20 | 31 | 66 |
| 80 | 4/2/2013 | 14 | 698 | 555 | 222 | 199 |
| 1 | 3/17/2013 | 110 | 30 | 0 | 34 | 11 |
| 64 | 11/22/2012 | 3500 | 149 | 44 | 110 | 999 |
| 4 | 9/15/2012 | 26541 | 12 | 12 | 41 | 21 |
| 65 | 3/3/2013 | 150 | 600 | 150 | 122 | 245 |
| 80 | 12/4/2012 | 18 | 13 | 7 | 24 | 5 |
| 2 | 11/22/2012 | 2800 | 125 | 120 | 1550 | 333 |
| 3 | 4/2/2013 | 591 | 90 | 45 | 65 | 26 |
Pay Scales
| Customer | Grapes | Apples | Grapefruit | Watermelon | Strawberries |
| 20 | 2.25 | 0.33 | 0.21 | 0.18 | 0.98 |
| 1 | 2.01 | 0.39 | 0.25 | 0.17 | 1.01 |
| 3 | 2.22 | 0.41 | 0.27 | 0.25 | 1.05 |
| 80 | 3.5 | 0.295 | 0.22 | 0.22 | 0.99 |
| 2 | 1.98 | 0.35 | 0.29 | 0.21 | 0.87 |
| 4 | 2.5 | 0.38 | 0.28 | 0.23 | 0.89 |
| 65 | 2.57 | 0.31 | 0.215 | 0.21 | 1.01 |
| 64 | 1.99 | 0.44 | 0.3 | 0.19 | 1.05 |
| 85 | 3.3 | 0.39 | 0.4 | 0.22 | 0.95 |
