CREATE OR REPLACE MACRO wil_lo(x, n) AS CASE WHEN n=0 THEN NULL ELSE ((x/n + 1.96^2/(2*n)) - 1.96*sqrt((x/n)*(1-x/n)/n + 1.96^2/(4*n^2)))/(1+1.96^2/n) END ; --; CREATE OR REPLACE MACRO wil_hi(x, n) AS CASE WHEN n=0 THEN NULL ELSE ((x/n + 1.96^2/(2*n)) + 1.96*sqrt((x/n)*(1-x/n)/n + 1.96^2/(4*n^2)))/(1+1.96^2/n) END ; --; -- @F10 U1 con publicidad por licitación (al menos un lote casado por E1/E2) SELECT anio, count(*) n_lic, round(100.0*avg(lo::INT),1) pct_lo, round(100*wil_lo(sum(lo::INT)::DOUBLE,count(*)),1) lo95, round(100*wil_hi(sum(lo::INT)::DOUBLE,count(*)),1) hi95, round(100.0*avg(hi::INT),1) pct_hi FROM (SELECT lic, min(anio) anio, bool_or(pub_lo) lo, bool_or(pub_hi) hi FROM fin WHERE u1 AND estrato='con_publicidad' GROUP BY lic) GROUP BY ROLLUP(1) ORDER BY 1