Task $1$: Create a view named SMALL$\_$PROPERTY. It consists of the property ID$,$ office number, bedrooms, floor, monthly rent, and owner number for every property whose square footage is less than $1,250$ square feet.

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.

Task $3$: Without using the SMALL$\_$PROPERTY VIEW, retrieve the office number, property ID$,$ and monthly rent for every property whose square footage is less than $1,250$ square feet and a monthly rent of $$1150$ or less.

Task $4$: Create a view named PROPERTY$\_$OWNERS. It consists of the property ID$,$ office number, square footage, bedrooms, floors, monthly rent, and owner$$s last name for every property in which the number of bedrooms is three.

Task $5$: Write and execute the command to retrieve all information for a property for every property in the PROPERTY$\_$OWNERS view with a monthly rent of less than $$1675.$