average_kli, min(klicount) as min_kli, max(klicount) as max_kli,(select count(distinct(kli))from ad_delivery.sgmt_kli_adica where a.partner_id = $1) as total_distinct_kli, a.partner_id
from
.dim_date c on a.date_id = c.date_idjoin ad_delivery.sgmt_adice on d.adic::varchar = e.adicjoin ad_delivery.ox_bannersf.banner_id
join ad_delivery.ox_campaigns h on h.camp