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?

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'

Answer 1

The correct WHERE clause syntax to query Counties in Florida with a population between 50,000 and 100,000 in 2008 is Option D, which precisely filters by population range and state.

Step-by-step explanation:

To find all the Counties with a population greater than 50,000 and less than 100,000 in the state of Florida in the year 2008 using the Select by Attributes tool, the correct WHERE clause syntax would be:

D. ("Counties.POP2008" > 50000 AND "Counties.POP2008" < 100000) AND "Counties.STATE_NAME" = 'Florida'

This condition first checks that the population in 2008 (POP2008) is greater than 50,000 and then checks that it is also less than 100,000, specifically for Counties within the state of Florida. Options A, B, and C contain various errors or are incorrectly constructed, making D the correct choice.