-- Verificación de atributos en la tabla maestra
SELECT
dpto,
dist,
count(*) as total,
count(NULLIF(snc_cuenta, '')) as con_cuenta_real,
count(NULLIF(ccatastral, '')) as con_catastro
FROM public.snc_raw_lotes_activos
WHERE dpto = 'F' AND dist = 1
GROUP BY dpto, dist;
