check_map_colors_505.sql 214 Bytes

Edit Raw Blame History

SELECT
    count(*) as total_geometrias,
    count(inm_ficha) as lotes_con_deuda_coloreados,
    round(count(inm_ficha)::numeric / count(*)::numeric * 100, 2) as cobertura_mapa
FROM public.vw_lotes_morosidad_505;