Refer to the Exhibit

Refer to the exhibit. An engineering supervisor at a water utility asks the GIS analyst to find all pipes that are less than 10 inches in diameter. The analyst prepares a Select By Attribute query on the geodatabase feature class: Diameter < 10 When validating this SQL query, the analyst gets the error: "There was an error with the expression." What is invalid about the query?

A) Field name must be in enclosed in brackets: [Diameter]
B) Field name must be in enclosed in single quotes: 'Diameter'
C) Diameter is a text field but is using a numeric comparison
D) Query should include Diameter > 0 and < 10