Select by Attributes misses records?

[MattWilkie1]

Has anyone had this happen to them? I'm running Select By Attributes on a feature class to select shape area less than 300, but only a fraction of the records are being selected. This screenshot is after the query has been run. I've verified the selection is New Selection and not Reselect from a previous selection. The table is sorted on Shape_Area. It's clear that 20 of 24 visible rows should be selected, but only 13 actually are. I've pressed [refresh table] at bottom right after running the query. I've replicated these bad results several times, but all in this same session (I haven't yet tried closing Pro and trying again).

The table is a polygon feature class in a file geodatabase. ArcGIS Pro 2.8.1.

[Lebowski]

Here is a screenshot of my map, no matter what modify tool I run and keeping getting this error. I am running Pro version 2.8.2

[Scott_Harris]

To close the loop: I spoke with @Lebowski and they had non-editable annotation, but were running the tool to upgrade the annotation (possibly at the same time), which most likely put a schema lock on the database. Therefore none of the data was editable and the modify tools were filtering the non-editable features from the selection.