Fun With Queries

Practice using Properties database.

• Cheap Family ##: Listing ID, address, Price, Agent with 3 or more bedrooms, under $100,000 sorted descending by price.
• Mr.&Mrs. Retiree ##: Listing ID, address, price, agent with exactly 2 bedrooms, wood only, any price
• Starter Home ##: 2 or more bedrooms, less than $90,000, no brick, sorted descending by number of bedrooms.