Given tables: CUSTOMER (CUST_ID (PK), CUST_LAST, CUST_FIRST, CUST_PHONE, CUST_EMAIL, CUST_ADDRESS, CUST_CITY, CUST_ZIP, CUST_STATE) ORDERS (ORDER_NUMBER (PK), CUST_ID (FK), PROD_ID (FK), ORDER_DATE, ORDER_TOTAL) PRODUCT (PROD_ID (PK), PROD_DESCRIPTION, PROD_CATEGORY, PROD_PRICE)

RELATIONAL ALGEBRA ONLY

1. Retrieve City and Email for the customer whose name is John Smith.
2. Retrieve Name and Address of all customers who live in Florida.
3. Retrieve Product Description and Price for the products in the Computer category that cost more than $100.
4. Retrieve Product Description and Price for the products in either the Computer or Game category.
5. Retrieve Name and Address of the customers who placed orders on 01-01-2016. Note: the CUSTOMER and ORDERS tables are linked through the CUST_ID column.
6. Retrieve Product Description and Price for the products that were purchased on 01-01-2016. Note: PRODUCT and ORDERS tables are linked through the PROD_ID column.
7. Retrieve Name and Address of all customers who live in Florida, who purchased product TV.
8. 9. 10. Write three more complex queries to retrieve data from these tables. Queries must include multiple conditions and incorporate at least one join, one rename, and one aggregate function operations. All queries must be different. Provide a clear explanation of what each query is intended to do.