Chapter 8 Questions:

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

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

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

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 houses

5.    What exact query did you use to select the correct parcels in #4?  Copy and paste it here:  "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.00

7.    What are the names of the two cross streets for this parcel (in #6, above)? Texas and Colton Streets

8.    Who owns the parcel immediately to the south of this parcel (in #6, above)? The Salvation Army

Chapter 9 Questions:

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 operator needs to submit plan to LADNR for clean-up procedure for approval
             29_p_158 <null>
             50_w_26291 operator needs to submit plan to LADNR for clean-up procedure for approval