Com relação às tabelas cliente e visita, descritas anter

A

delete from cliente

where not exists

   (select * from visita v

      where v.codigo in cliente.codigo)

B

delete from cliente

where not exists

    (select * from visita v

       where v.codigo <> cliente.codigo)

C

delete from cliente

where codigo in (select codigo from visita)

D

 delete from cliente

where codigo <> ALL (select codigo from visita) 

E

delete from cliente

where (select count(*) from visita v

              where v.codigo <> cliente.codigo) > 0