1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| SELECT C.icat_agr,COUNT(DISTINCT E.iets) FROM r_etablissement E, r_histo_etats_ets H1, r_enseignement_ets C
WHERE E.iets = H1.iets
AND E.iets = C.iets
AND C.icat_agr IN (SELECT icat_agr FROM r_cat_agr )
AND H1.ietat IN (2,3,4,7)
AND H1.date_effet_ets IN (SELECT MAX(date_effet_ets) FROM r_histo_etats_ets H2
WHERE H1.iets = H2.iets
AND H2.date_effet_ets <= '10/10/1990' )
AND E.idep = '01' group by icat_agr;
C.icat_agr COUNT(DISTINCT E.iets)
1 60
2 114
3 7
4 4
5 7
7 16
8 72
9 1
10 114 |
Partager