Yeah you can’t do that with a Query Field.
The historical data is logged in EventLog entries, these are queryable but I dont think you an query what you want in the Query fields on the Site.
I prefer to avoid queries for these “very static” situations that do not depend on many things moving.
Depending on your instance’s activity, and how many of these queries are happening at once (let’s say you have a 100-200 item page), querying the event log can become painfully slow.
We have a similar need but to count retakes instead of finals and we use a very simple webhook that gets triggered on task status change, it just checks whenever the status is changed to ‘rtk’ and if after a 5 minute delay (to avoid user-error on status changes) the status is still ‘rtk’ it adds +1 to a field. This way you have a plain text field that can very easily be filtered to find struggler shots, which you cannot do with queries.