SQL Query Deleted Assets

I am looking for a sql query for assets removed for specific dates. Example - removed assets from 6/23 - 6/30. Can someone provide some assistance please?

Thanks!

Removed as in deleted manually or Purged? i dont think thats possible cause if they are deleted manually or purged via a RULE, that assetID is removed the databases, at least from what i understand..however i do know that historical data may or could be still present as i have seen it in the scan history… id have to look over whats available.. in the DB…