[[fjcg02]]

Creo que esta es la solución a tu problema, por lo menos en SQL Server.
Espero que te sirva de ayuda.

select max(P.inname) as ZONA, HW.localizacion,
max(case clase when 'Servidor' then Mantenedor else '' end ) as ST_OFICINA,
HW.modelo, max(subclase) as Subclase,
count( modelo) as TOTAL,
sum(case isnull(f_finGarantia, 0) when 0 then 1 else 0 end) as MANT,
sum(case isnull(f_finGarantia, 0) when 0 then 0 else 1 end) as GARANT
from vistaassetshw HW, mantenimientodet M, relationships R, INDIVID P, INDIVID P2
where
HW.idasset = M.idasset group by localizacion, modelo
order by zona, localizacion, ST_OFICINA desc, subclase, modelo