-- Verificación de Oviedo tras Ingesta Nacional
SELECT 
    dpto, 
    dist, 
    count(*) as total_lotes,
    count(snc_cuenta) as con_cuenta_limpia
FROM public.snc_raw_lotes_activos 
WHERE dpto = 'F' AND dist = 1
GROUP BY dpto, dist;