Código:
SELECT sum(SbC.prod) as productores, sum(SbC.adm) as administrativos
FROM (SELECT 0 as prod, count(*) as adm
FROM empleados WHERE tipo = 'administrativo'
UNION ALL
SELECT count(*) as prod, 0 as adm
FROM empleados WHERE tipo = 'produccion') as SbC;
mas simple
Código:
Select sum(iif(tipo = 'produccion',1,0)) as productores,
sum(iif(tipo = 'administrativo',1,0)) as administrativos
FROM empleados;
la función iif(condicion,siVerdadera,siFalsa) varia segun que servidor de bbdd uses...
Quim