Untitled

 avatar
unknown
sql
2 years ago
286 B
3
Indexable
SELECT  count(*)  FROM `rs-shr-al-analyticsz-prj-ebc1.anl_persona.cliente_persona` 
WHERE periodo="2023-04-01"
AND id_cliente_persona NOT IN 
  (
    SELECT id_cliente_persona FROM `rs-shr-al-analyticsz-prj-ebc1.anl_persona.cliente_persona` 
    WHERE periodo = "2023-03-01"
  )