Create another query that displays all fields, except the ID field, for all properties with selling prices less than $1,000,000.

Topic: Week 8 Final Project The Scenario: Tony Spacken, Sales Manager, has an Excel workbook listing properties for sale. If a property is sold, Select National Properties Group will finance the property loan for 30 years at 7.5% interest. If the monthly payment of a property is greater than $300,000, the company will give the […]