2. WasteNot Recycling WasteNot Recycling is an organization that picks up recyclables from homeowners in Boulder, Colorado, as introduced in Plug-In T6. The CUSTOMER table holds static customer information such as name, address, and phone. The CUSTOMER RECORD table holds data about each recyclable pickup. Enough test data has been added to each table to test queries. The owners of WasteNot Recycling have asked you to assist with creating several queries. Specifically they need you to do the following: 1. Create a query using the CUSTOMER data that will select records for customers who had their first pickup in May 2004. Sort the records by customers Last Name. Save the query as May Pickup Query. 2. Create a query on CUSTOMER RECORD to determine the total weights of paper and other products each customer has had picked up. Use the CUSTOMER Last Name and First Name in the query. Save the query as Customer Weight Query. 3. Create a query using the Name, Street, Address, and Weight fields from the CUSTOMER DETAIL table. Enter the criteria that will select customers with less than 10 pounds in either recyclable field. Save the query as Low Volume Query.

Customer. Last Nar-First Na-l-Street -FirstPickup 5480 Alpine Street Bouder CO 80308 (303) 161-5545 05/25/2004 | Sta ZipCo( | Phone 1 Wagoner Sam 2 Calahan Eliza 2140 Edgewood Ave Boulder CO 80308 (303) 886-6003 05/25/2004 3 Lake 4 Meadows Sara James 701 Eastman Road Boulder CO 80308 (303) 562-4499 08/25/2005 Pond Hill Drive 114 Lexington Street 431 Philips Lane Boulder CO 80308 (303) 792-3646 02/28/2004 CO 80308 (303) 838-7111 Boulder CO80308 (303) 352-4847 07/17/2005 oulder CO 80308 (303) 555-6731 05/19/2005 Boulder CO 80308 (303) 815-2456 12/28/2004 Alto Boulder 06/02/2004 20 Smith 64 Monarch Shiela 65 Guo 80 RiveraJuan 85 Williams Max Amy1935 Snow Ave 482 Weston Ave 230 Southpark Circle Boulder