MySQL delete from where in 更新子句

delete from如何修改和删除同一个表中的字段

delete from history where ind in (select a.ind from (select ind from history where year=2021 and group_id=3 and month=7) as a)