A GIS analyst has a countrywide parcel dataset and needs to determine the property owners for the northern region of the country. The analyst wants to find owners whose last name contains Jon.
The correct SQL expression should filter parcels that are both in the North region and where the OwnerName field contains 'Jon.' The LIKE operator is appropriate when matching patterns or partial names.
Option A correctly combines both conditions using AND.
Option B would include any parcel in the North region or any parcel where OwnerName contains Jon, which is overly broad.
Option C incorrectly uses exact equality, which would fail to match variations like 'Johnson' or 'Jonas.'
Note: The LIKE expression typically includes wildcard characters (e.g., LIKE '%Jon%') but based on provided options, Option A represents the correct logic.
Therefore, the correct answer is A.
—
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit