如果您的情况与您所描述的完全相同，并且您确实没有相关的时间戳来检查之前发生的事情和之后发生的事情，那么您可以删除其活动为“deletion”或“deletion complete”的所有行，并且其orderid等于具有“in storage”活动的任何行的任何order id。
但是，如果“in storage”需要在“deletion”或“deletion complete”之前发生，那么您还需要在下面使用的子选择中验证。

-- create the example table - drop any table of that name existing before ...
DROP TABLE IF EXISTS input;
CREATE TABLE input(OrderID,Activity) AS (
          SELECT 1,'Item Started'
UNION ALL SELECT 1,'Task 1 complete'
UNION ALL SELECT 1,'In storage'
UNION ALL SELECT 1,'Deletion'
UNION ALL SELECT 1,'Deletion Complete'
UNION ALL SELECT 2,'Item Started'
UNION ALL SELECT 2,'Deletion'
UNION ALL SELECT 2,'Deletion Complete'
);
-- here goes 
DELETE
FROM  input
WHERE orderid IN (
  SELECT orderid FROM input WHERE activity='In storage'
)
  AND activity IN('Deletion','Deletion Complete')
;

您可以分两步删除第一步删除“存储中”不可用的所有记录

DELETE FROM table t1 WHERE 
 not exists ( select 1 from table t2 where t1.id=t2.id
                                 and Activity in ('In storage')
 )

第二步“存储中”可用

DELETE FROM table t1 where activity in('Deletion','Deletion Complete')