1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| select A.annee, libelle_district,
year(bt_etat41_mens_t1.BT_E41_DAT) as annee,
(bt_etat41_mens_t1.BT_E41_SF410100 +1) as SF ,
(bt_etat41_mens_t1.BT_E41_CRED410100 + bt_etat41_mens_t5.BT_E41_S_ENCOURS410100 )as cred ,
(bt_etat41_mens_t5.BT_E41_SI410100 +1) as SI
from `bt_etat41_mens_t1` , `bt_etat41_mens_t5`, `district`
right join annee as A
on A.annee = year(bt_etat41_mens_t1.BT_E41_DAT)
where
district.code_district = bt_etat41_mens_t1.RC_UR_CODE
and bt_etat41_mens_t1.RC_UR_CODE = bt_etat41_mens_t5.RC_UR_CODE
and bt_etat41_mens_t1.RC_REGION_CODREG = bt_etat41_mens_t5.RC_REGION_CODREG
and bt_etat41_mens_t1.BT_E41_DAT = bt_etat41_mens_t5.BT_E41_DAT
AND libelle_district = 'Tunis ville'
and month(bt_etat41_mens_t1.BT_E41_DAT)='2'
order by year(bt_etat41_mens_t1.BT_E41_DAT) desc |
Partager