SELECT DISTINCT

SQR$\_$FT$,$

AVG$($MONTHLY$\_$RENT$)$ OVER $()$ AS AVG$\_$MONTHLY$\_$RENT

FROM

PROPERTY

HAVING

AVG$($MONTHLY$\_$RENT$)>1100$;