Task 2: Write and execute the command to retrieve the office number, property ID, and monthly rent for every property in the SMALL_PROPERTY view with a monthly rent of $1150 or more. This is my response. However it isn't working when I check the file. Also the table isn't popping up like the other completed queries, can you let me know where I went wrong and provide correct reponse. Thanks, CREATE VIEW TASK2 AS  SELECT OFFICE_NUM, PROPERTY_ID, MONTHLY_RENT FROM SMALL_PROPERTY WHERE MONTHLY_RENT < 1150;

1)To list the number of equipment with the same first three letters (the start code, e.g., CAM, DIV) in the equipment code for equipment loaned or returned in the month of June. You should list the start code and the number of equipment types ONLY if there is more than 2 such equipment with the start code.2) Create a view named CustomerSummary with details of each customer, the number of equipment rented, the total amount of rental collected thus far and the number of damages caused by customer and not due to wear and tear.3) Use the CustomerSummary view to find the average rental per loan for the customer with the most number of loans. Do not hardcode any value and do not assume that the loan table is non-empty or that there is one row of result as ingeneral, there may be more than one customers with the most number of loans.

Task 7: Create a view named MONTHLY_RENTS. It consists of three columns: the first is the number of bedrooms, the second is the average square feet, and the third is the average monthly rent for all properties in the PROPERTY table that have that number of bedrooms. Use BEDROOMS, AVG_SQUARE_FEET, and AVG_MONTHLY_RENT as the column names. Group and order the rows by number of bedrooms. Task 8: Write and execute the command to retrieve the average square footage and average monthly rent for each property for which the average monthly rent is greater than $1,400.

Create a view named Refill_Due. It should consist of the patient id, dateofvisit, rxid, and the dosage for every medicine prescribed that requires refilling. Prefix the columns in the view with “RD”. For example, the PATIENTID in the table becomes RD_PATIENTID in the view. Use select statement to display the records from the view just created. See the output below and match your results to the sample output.