What is the correct SQL statement to use to select all zones designated type E, F, or FF?

A city planner is using ArcGIS to determine suitable areas that meet specific zoning criteria. The city’s zoning polygon feature class has a ZONE attribute field that consists of one- or two-letter codes.

What is the correct SQL statement to use to select all zones designated type E, F, or FF?
A . ZONE = ‘E’ AND ZONE = ‘F’ OR ZONE = ‘FF’
B . ZONE IN (‘E’, ‘F’, ‘FF’)
C . ZONE = ‘E’ OR ZONE = ‘F%’
D . ZONE CONTAINS (‘E’, ‘F’, OR ‘FF’)

View Answer

Answer: D