ça va faire ça :


[code:qf0bi3x3]
SELECT
	service,
	sum(CASE WHEN macondition de recherche1 THEN 1 ELSE 0 END) AS nb_blabla,
	sum(CASE WHEN macondition de recherche2  THEN 1 ELSE 0 END) AS nb_blibli
FROM matable
	et mes jointures
WHERE 
	condition de recherche commune
GROUP BY service
ORDER BY  cequetuveux[/code:qf0bi3x3]