SQL逻辑 - 记录字段已更改但自此以后没有更改

I have a situation where I need to locate all member records that changed from a status of active to a status of freeze in a period of time. The issue is, a member can change statuses multiple times. For example, a member can change their status from active to freeze on June 1. Then back to active on September 1 and then back to freeze for December 1. I am trying to run a query to identify all of the members who froze from June 1 and are still frozen but that have not changes their status in between.I have a situation where I need to locate all m