Q4. (4) Were going to be increasing some condo fees. For each condo that is over 1000 square feet but under 1500 square feet, find the building, unit, and current weekly fee. List by building.

Q5. (4) We want to offer vacation weeks at a discount for all guests who visited in 2017 from Northeastern states; New York, New Jersey, Massachusetts, Connecticut, Pennsylvania, and New Hampshire. Find the state, last name, and phone number; show alphabetically by state.

Code these queries within SQL Server. Below is the EERD.

Family Adventure Resorts PERSONNE Name Name hone HOUSEKEEPING IKI CLEANING HKID FAMILIES CONDOS uesra Fna Condo GUIDES drms GUEST Fee LName CONDOSTAYS ACTIVITIES RESERVATIONS RID Guest AID TotalFeePaid] Hrs RDate Type TotalCost INVOICE INVOICEDETAILS Guest# RLName Departure Date] CondoFee] Details Totall Invoice Total SalesTax] Person Price] Activity Total Details Total