Esri
EADA10 · Question #73
Given a layer called Counties with the following relevant attributes: - POP2008 - POP2000 - STATE_NAME What is the correct WHERE clause syntax for Select by attributes tool that should be used to…
The correct answer is A. ("Counties.POP2008" > 50000 AND < 100000) AND "Countries.STATE_NAME" = `Florida'. See the full explanation below for the reasoning.
Question
Given a layer called Counties with the following relevant attributes:
- POP2008
- POP2000
- STATE_NAME
What is the correct WHERE clause syntax for Select by attributes tool that should be used to find all the Counties with a population greater than 50000 and less than 100000 in state of Florida in year 2008?
Options
- A("Counties.POP2008" > 50000 AND < 100000) AND "Countries.STATE_NAME" = `Florida'
- B("Counties.POP2008" > 50000 AND "Counties.POP2000" < 100000) AND "Counties.STATE_NAME" = `Florida'
- C("Counties.POP2008" > 50000 AND "Counties.POP2008" < 100000 AND "Counties.STATE" `Florida')
- D("Counties.POP2008" > 50000 AND "Counties.POP2008" < 100000) AND "Counties.STATE_NAME" = `Florida'
How the community answered
(41 responses)- A73% (30)
- B15% (6)
- C2% (1)
- D10% (4)
Community Discussion
No community discussion yet for this question.