Please show appropriate relational calculus RANGE statements and a single GET statement to answer each of the following. 1. (1 pt) Find the propld, locDesc, and state for properties with a propType equal to "T" (i.e., traditional). 2. (2 pts) Find the propld and startDt for properties which the customer named Ava Kashun has a rental. 3. (4 pts) Find the property ID and locDesc of properties in TX (state) which have a start date after "2019-11-03" forthe customer named "Perry Scope". 4. (6 pts) Find the customer numbers and names of customers who have a rental start after "2019-11-04" for a property which customer #444 also had a rental. Do not include #444 in your result. Hint: you will have to use one of the relations twice. 5. (4 pts) Find the customer number and names of customers who have rented all of the properties having a prop Type of "C" (Camping). 6. (6 pts) Find the custNr, name, gender, and birth date of customers who only rent properties with a state equal to "CO". State whether your answer includes customers that don't have any associated rentals. 7. (4 pts) Find the propld and locDesc for properties on which only customer#777 has a rental. State whetheryour answer includes properties that don't have any associated rentals. 8. (7 pts) Find the customer numbers and names of customers who have rented all the properties which Penny Lane has rented. State whether you included Penny Lane in your answer . 9. (6 pts) Find the customer number, names, and birth date for customers who never rented a property with a state equal to "CO". State whetheryour answer includes customers that don't have any associated rentals