1. How many houses in Neighborhood parcels have more than 1600 square feet of space?
    7

2. How many houses in Neighborhood parcels have a pool?
    5

3. How many houses in Neighborhood parcels have 3 or more bedrooms and 1.5 or more bathrooms?
    12

4. How many houses in Neighborhood parcels are for sale for less than $100,000 and have at least 1000 square feet of space?
    11

5. What exact query did you use to select the correct parcels in #4?  Copy and paste it here:
"STATUS" = 'Y' AND "SALE_PRICE" <100000 AND "SQ_FT" >=1000

6. Among the properties in Other parcels, what is dollar value of the parcel with the highest property value? 
    $1,175,032
   
7. What are the names of the two cross-streets for this parcel (in #6, above)?
    Colton and Texas
8. Who owns the parcel immediately to the south of this parcel (in #6, above)?
    Salvation Army
•    As directed at the end of Exercise 8c on p. 224, print a copy of the report you have created and put your name on it before you turn it in.

•    At the end of Exercise 9b, Step #28 on p. 251, follow the directions in the paragraph that starts “An interesting follow-up to your work...”  When you have completed these steps, copy and paste the following questions and your answers onto your Lab 5 web page.

9. What is the file extension used to designate a data or attribute table? (Hint: These are known as database files.)
    dbf
10. What are the ID numbers and recommended remedial actions for each of the pits containing lead?
         23_w_15134
          29_p_158
          50_w_26291