Comment procéder si je veux rechercher tous les établissements d'enseignement technique d'un département donné ? (GB)

Requête générique : trouver une institution avec un statut et une activité

-- essai sans association au projet
WITH
statut AS
	(
	SELECT
		object_label,
		fk_associated_object,
		fk_type_role,
		fk_information		
	FROM
		bhp.information_role
	WHERE
		fk_associated_object = 'AbOb1881'
		AND
		fk_type_role = 140
	),
activite AS
	(
	SELECT
		object_label,
		fk_associated_object,
		fk_type_role,
		fk_information		
	FROM
		bhp.information_role
	WHERE
		fk_associated_object = 'AbOb1674'
		AND
		fk_type_role = 131
	)
SELECT
	ir.object_label AS institution,
	statut.object_label AS statut,
	activite.object_label AS activité
FROM
	bhp.information_role ir,
	statut,
	activite
WHERE
	statut.fk_information = activite.fk_information
	AND
	activite.fk_information = ir.fk_information
	AND
	ir.is_information_subject IS TRUE
ORDER BY
	ir.object_label