Union de consultas

[quimfv]

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