SQL中如何删除指定查询出来的数据

DELETE FROM customer1
WHERE agent_code=ANY(
SELECT agent_code FROM agents
WHERE working_area='London');

SELECT CustId, CustName, CustAddress, CustPhone FROM Original
EXCEPT
SELECT CustId, CustName, CustAddress, CustPhone FROM Revised

ELETE FROM customer1
WHERE agent_code=ANY(


Select UserID
From Original
Where UserID not like '[0-9]%'

EXCEPT

SELECT 
UserID
FROM Revised as cs
Left join [TTID] on cs.CustId = TTID.CustId
where cs.UserID not like ''

)