Question

1. Create a query using the Customer Information data that will select recordsfor customers who had their first pickup in May 2004. Sort the records by customer’s Last Name. Save the query as May Pickup Query. 2. Create a query on Pickup Records and Customer Information 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 Pickup Records and Customer Information tables. Enter the criteria that will select customers with less than 10 poundsin either recyclable field. Save the query as Low Volume Query.

Answer 1

Answer:

select * from CUSTOMER where FirstPickup >= to_date ('05/01/2004','MM/DD/YYYY') and FirstPickup <= to_date ('05/31/2004','MM/DD/YYYY') order by LastName asc;