Count number of SQL records in the same field

You add the columns with a case example:

Select (resto de columnas).., SUM(CASE cap.id_tipo_actividad WHEN 1 then 1 else 0 END) as control_foco1, SUM(CASE cap.id_tipo_actividad WHEN 2 then 1 else 0 END) as control_foco2

The idea is that the case function returns the value 1 when it is the expected result so that it can be added with the SUM function, if it is not the expected value it is left at 0 so that it does not affect the sum.

NOTE: check the syntax of the case clause since I did it on the fly.

Greetings.

You can use the Compute By clause, but it gives you the result in another set of data instead of adding it as a row that is what you want. To achieve this, use a Union all by removing the column by which you do the group by

SELECT dep.nombre as departamento,                   
sum(cap.total_mosquitos) as total_mosquito,
sum(cap.total_anopheles) AS total_anopheles,
sum(cap.casa_positiva)   AS casa_positiva,
sum(cap.casa_inspeccionada) AS casa_inspeccionada,
sum(cap.componente_inspeccionado) AS componenente_inspeccionado,
sum(cap.tiempo_colecta)  AS tiempo_colecta,
count(cap.id_tipo_actividad) AS programa_regular    
FROM pl_captura_anopheles cap
inner join ctl_caserio cas on (cap.id_caserio =cas.id)
inner join ctl_canton can on (cas.id_canton = can.id)
inner join ctl_municipio mun on (can.id_municipio = mun.id)
inner join ctl_departamento dep on (dep.id=mun.id_departamento)
inner join pl_tipo_captura tc   on(cap.id_tipo_captura=tc.id)
inner join ctl_pl_tipo_actividad act   on(cap.id_tipo_actividad=act.id)
where  (EXTRACT(YEAR FROM cap.fecha)=2018)
group by dep.nombre

union all

SELECT 'Totales',              
sum(cap.total_mosquitos) as total_mosquito,
sum(cap.total_anopheles) AS total_anopheles,
sum(cap.casa_positiva)   AS casa_positiva,
sum(cap.casa_inspeccionada) AS casa_inspeccionada,
sum(cap.componente_inspeccionado) AS componenente_inspeccionado,
sum(cap.tiempo_colecta)  AS tiempo_colecta,
count(cap.id_tipo_actividad) AS programa_regular    
FROM pl_captura_anopheles cap
inner join ctl_caserio cas on (cap.id_caserio =cas.id)
inner join ctl_canton can on (cas.id_canton = can.id)
inner join ctl_municipio mun on (can.id_municipio = mun.id)
inner join ctl_departamento dep on (dep.id=mun.id_departamento)
inner join pl_tipo_captura tc   on(cap.id_tipo_captura=tc.id)
inner join ctl_pl_tipo_actividad act   on(cap.id_tipo_actividad=act.id)
where  (EXTRACT(YEAR FROM cap.fecha)=2018)

That's the idea in general, to get to your requirement you must adapt the part of the second select. It was not very clear to me exactly what you want to tell