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!