question archive 1) This SQL expression is correctly formatted to select residential parcels worth more than 100,000: [Zoning] = 'Residential' AND [VALUE] > 100000 Correct Incorrect 2) Suppose that you have some trail mix composed of peanuts, raisins, almonds, cashews, cranberries, and chocolate candies colored red, green, yellow, and orange
Subject:GeographyPrice: Bought3
1) This SQL expression is correctly formatted to select residential parcels worth more than 100,000: [Zoning] = 'Residential' AND [VALUE] > 100000
Correct
Incorrect
2) Suppose that you have some trail mix composed of peanuts, raisins, almonds, cashews, cranberries, and chocolate candies colored red, green, yellow, and orange. You apply the following set of "queries":
Create new selection: all candies.
Add to selection: cashews.
Remove from selection: red and green candies.
Select from selection: all nuts and candies.
What do you have selected when you are finished?
cashews, yellow candies, orange candies
everything except raisins and cranberries
almonds, peanuts, and red candies
peanuts, red candies, and green candies
