Q. CUSTOMER (CID, NAME, STREET, CITY, STATE, AGE) SALE (PID, CID, DATE, COST) PART (PID, PNAME, COLOR) The meaning of these relations is straightforward; for example, SALE has one tuple for every part sold to a customer. Primary key attributes are underlined. For instance, PID and CID together form the primary key of relation SALE. SALE.PID is a foreign key that refers to PART.PID, while SALE.CID is a foreign key that refers to CUSTOMER.CID. Write SQL statements for the following retrieval and update operations. 1. Find the names and addresses of customers who bought parts averaging more than $50. 2. For each customer of the city of Trenton who bought more than 5 distinct red parts, retrieve his/her CID and the total number of parts that he/she bought. 3. Retrieve the names of the red parts sold at a price lower than that of every blue part. 4. Only customers from the city of Princeton can buy orange parts. 5. No customer is allowed to buy more than 10 (not necessarily distinct) orange parts