Without having some way of knowing the previous status there is no query that can accomplish this.

If you add a trigger or modify the update logic to write either a flag or an audit record you could accomplish it.

But what you have described would typically be stored in a single field of a single row. So we only know the current state. How or if it changed cannot be determined..

CEWII