@MasoudT9 What is your requirement? Do you want permanently purge those records? or Maintain it in a seperate instance so that can be restored later?

As purge/archieve wizard would generate zip file so that when you want to restore it you can do that.  But if you take it from SQL approach you just want to delete the records or take it as backup?

@MasoudT9

The assumption to this answer is that you want to delete the work objects permanently.

 In that case, you need to handle primarily 3 tables :

   -- Assignment table (a IN query to handle the resolved cases)

              delete from pc_assign_worklist where pxrefobjectinsname in (select pyID from pc_work where pyStatusWork like 'Resolved-%')                 

-- History table

              delete from pc_history_work where pxhistoryforreference in (select pzInsKey from pc_work where pyStatusWork like 'Resolved-%')

    -- Work table               delete from pc_work where pyStatusWork like 'Resolved-%'

The deletion should be done in this order, and taking care of these 3 tables would be enough for you.