11.60 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ENERGIE' and pole = 'Pole Territoire Sud-Est'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ENERGIE' and pole = 'Pole Territoire Sud-Est' ; Copy
5.65 ms
10
SELECT t0 . id AS id_1 , t0 . communeb AS communeb_2 , t0 . cout AS cout_3 , t0 . secteurb AS secteurb_4 , t0 . libelle AS libelle_5 , t0 . demarrage AS demarrage_6 , t0 . latitude AS latitude_7 , t0 . longitude AS longitude_8 , t0 . geolocalisation AS geolocalisation_9 , t0 . georeferencement AS georeferencement_10 , t0 . cl_id AS cl_id_11 , t0 . generique_id AS generique_id_12 , t0 . convention_id AS convention_id_13 , t0 . secteur_id AS secteur_id_14 FROM realisations t0 WHERE t0 . secteur_id = ?
SELECT t0 . id AS id_1 , t0 . communeb AS communeb_2 , t0 . cout AS cout_3 , t0 . secteurb AS secteurb_4 , t0 . libelle AS libelle_5 , t0 . demarrage AS demarrage_6 , t0 . latitude AS latitude_7 , t0 . longitude AS longitude_8 , t0 . geolocalisation AS geolocalisation_9 , t0 . georeferencement AS georeferencement_10 , t0 . cl_id AS cl_id_11 , t0 . generique_id AS generique_id_12 , t0 . convention_id AS convention_id_13 , t0 . secteur_id AS secteur_id_14 FROM realisations t0 WHERE t0 . secteur_id = 1 ; Copy
2.00 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'COMMERCE ET ARTISANAT' and pole = 'Pole Territoire Sud-Est'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'COMMERCE ET ARTISANAT' and pole = 'Pole Territoire Sud-Est' ; Copy
1.82 ms
1
select COALESCE (COUNT (commune ), 0 ) AS total , pole from dbo . realisations_pole group by pole order by pole ASC
select COALESCE (COUNT (commune ), 0 ) AS total , pole from dbo . realisations_pole group by pole order by pole ASC ; Copy
1.73 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'AGRICULTURE , ELEVAGE ET PECHE' and pole = 'Pole Territoire Sud-Est'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'AGRICULTURE , ELEVAGE ET PECHE' and pole = 'Pole Territoire Sud-Est' ; Copy
1.72 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ENVIRONNEMENT ET ASSANISSEMENT' and pole = 'Pole Territoire Dakar'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ENVIRONNEMENT ET ASSANISSEMENT' and pole = 'Pole Territoire Dakar' ; Copy
1.67 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'AGRICULTURE , ELEVAGE ET PECHE' and pole = 'Pole Territoire Centre'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'AGRICULTURE , ELEVAGE ET PECHE' and pole = 'Pole Territoire Centre' ; Copy
1.54 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'EDUCATION ET FORMATION' and pole = 'Pole Territoire Sud-Est'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'EDUCATION ET FORMATION' and pole = 'Pole Territoire Sud-Est' ; Copy
1.42 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'EDUCATION ET FORMATION' and pole = 'Pole Territoire Diourbel-Louga'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'EDUCATION ET FORMATION' and pole = 'Pole Territoire Diourbel-Louga' ; Copy
1.39 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'HYDRAULIQUE' and pole = 'Pole Territoire Dakar'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'HYDRAULIQUE' and pole = 'Pole Territoire Dakar' ; Copy
1.37 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'SANTE' and pole = 'Pole Territoire Sud'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'SANTE' and pole = 'Pole Territoire Sud' ; Copy
1.37 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ENERGIE' and pole = 'Pole Territoire Diourbel-Louga'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ENERGIE' and pole = 'Pole Territoire Diourbel-Louga' ; Copy
1.37 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'AGRICULTURE , ELEVAGE ET PECHE' and pole = 'Pole Territoire Sud'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'AGRICULTURE , ELEVAGE ET PECHE' and pole = 'Pole Territoire Sud' ; Copy
1.37 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ENVIRONNEMENT ET ASSANISSEMENT' and pole = 'Pole Territoire Sud'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ENVIRONNEMENT ET ASSANISSEMENT' and pole = 'Pole Territoire Sud' ; Copy
1.37 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'EDUCATION ET FORMATION' and pole = 'Pole Territoire Sud'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'EDUCATION ET FORMATION' and pole = 'Pole Territoire Sud' ; Copy
1.36 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'COMMERCE ET ARTISANAT' and pole = 'Pole Territoire Diourbel-Louga'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'COMMERCE ET ARTISANAT' and pole = 'Pole Territoire Diourbel-Louga' ; Copy
1.35 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'COMMERCE ET ARTISANAT' and pole = 'Pole Territoire Sud'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'COMMERCE ET ARTISANAT' and pole = 'Pole Territoire Sud' ; Copy
1.35 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ROUTE' and pole = 'Pole Territoire Diourbel-Louga'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ROUTE' and pole = 'Pole Territoire Diourbel-Louga' ; Copy
1.35 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ENVIRONNEMENT ET ASSANISSEMENT' and pole = 'Pole Territoire Diourbel-Louga'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ENVIRONNEMENT ET ASSANISSEMENT' and pole = 'Pole Territoire Diourbel-Louga' ; Copy
1.35 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'SANTE' and pole = 'Pole Territoire Diourbel-Louga'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'SANTE' and pole = 'Pole Territoire Diourbel-Louga' ; Copy
1.34 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'HYDRAULIQUE' and pole = 'Pole Territoire Diourbel-Louga'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'HYDRAULIQUE' and pole = 'Pole Territoire Diourbel-Louga' ; Copy
1.34 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'AGRICULTURE , ELEVAGE ET PECHE' and pole = 'Pole Territoire Diourbel-Louga'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'AGRICULTURE , ELEVAGE ET PECHE' and pole = 'Pole Territoire Diourbel-Louga' ; Copy
1.34 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'HYDRAULIQUE' and pole = 'Pole Territoire Sud'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'HYDRAULIQUE' and pole = 'Pole Territoire Sud' ; Copy
1.34 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ROUTE' and pole = 'Pole Territoire Sud'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ROUTE' and pole = 'Pole Territoire Sud' ; Copy
1.34 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'JEUNESSE, SPORT, CULTURE ET LOISIRS' and pole = 'Pole Territoire Diourbel-Louga'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'JEUNESSE, SPORT, CULTURE ET LOISIRS' and pole = 'Pole Territoire Diourbel-Louga' ; Copy
1.34 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'JEUNESSE, SPORT, CULTURE ET LOISIRS' and pole = 'Pole Territoire Sud'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'JEUNESSE, SPORT, CULTURE ET LOISIRS' and pole = 'Pole Territoire Sud' ; Copy
1.33 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF' and pole = 'Pole Territoire Sud'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF' and pole = 'Pole Territoire Sud' ; Copy
1.33 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF' and pole = 'Pole Territoire Diourbel-Louga'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF' and pole = 'Pole Territoire Diourbel-Louga' ; Copy
1.33 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ENERGIE' and pole = 'Pole Territoire Sud'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ENERGIE' and pole = 'Pole Territoire Sud' ; Copy
1.32 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'COMMERCE ET ARTISANAT' and pole = 'Pole Territoire Centre'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'COMMERCE ET ARTISANAT' and pole = 'Pole Territoire Centre' ; Copy
1.31 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'HYDRAULIQUE' and pole = 'Pole Territoire Sud-Est'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'HYDRAULIQUE' and pole = 'Pole Territoire Sud-Est' ; Copy
1.31 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ENVIRONNEMENT ET ASSANISSEMENT' and pole = 'Pole Territoire Sud-Est'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ENVIRONNEMENT ET ASSANISSEMENT' and pole = 'Pole Territoire Sud-Est' ; Copy
1.30 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'JEUNESSE, SPORT, CULTURE ET LOISIRS' and pole = 'Pole Territoire Sud-Est'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'JEUNESSE, SPORT, CULTURE ET LOISIRS' and pole = 'Pole Territoire Sud-Est' ; Copy
1.29 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'SANTE' and pole = 'Pole Territoire Sud-Est'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'SANTE' and pole = 'Pole Territoire Sud-Est' ; Copy
1.29 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF' and pole = 'Pole Territoire Sud-Est'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF' and pole = 'Pole Territoire Sud-Est' ; Copy
1.28 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ROUTE' and pole = 'Pole Territoire Sud-Est'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ROUTE' and pole = 'Pole Territoire Sud-Est' ; Copy
1.27 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'DAKAR' and YEAR (date_signature )= '2023'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'DAKAR' and YEAR (date_signature )= '2023' ; Copy
1.25 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'TAMBACOUNDA' and YEAR (date_signature )= '2025'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'TAMBACOUNDA' and YEAR (date_signature )= '2025' ; Copy
1.23 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ENERGIE' and pole = 'Pole Territoire Dakar'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ENERGIE' and pole = 'Pole Territoire Dakar' ; Copy
1.22 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'HYDRAULIQUE' and pole = 'Pole Territoire Centre'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'HYDRAULIQUE' and pole = 'Pole Territoire Centre' ; Copy
1.21 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ENVIRONNEMENT ET ASSANISSEMENT' and pole = 'Pole Territoire Centre'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ENVIRONNEMENT ET ASSANISSEMENT' and pole = 'Pole Territoire Centre' ; Copy
1.20 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'SANTE' and pole = 'Pole Territoire Centre'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'SANTE' and pole = 'Pole Territoire Centre' ; Copy
1.19 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'EDUCATION ET FORMATION' and pole = 'Pole Territoire Centre'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'EDUCATION ET FORMATION' and pole = 'Pole Territoire Centre' ; Copy
1.19 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ENERGIE' and pole = 'Pole Territoire Centre'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ENERGIE' and pole = 'Pole Territoire Centre' ; Copy
1.18 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ROUTE' and pole = 'Pole Territoire Centre'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ROUTE' and pole = 'Pole Territoire Centre' ; Copy
1.18 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'JEUNESSE, SPORT, CULTURE ET LOISIRS' and pole = 'Pole Territoire Dakar'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'JEUNESSE, SPORT, CULTURE ET LOISIRS' and pole = 'Pole Territoire Dakar' ; Copy
1.18 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF' and pole = 'Pole Territoire Centre'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF' and pole = 'Pole Territoire Centre' ; Copy
1.17 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ROUTE' and pole = 'Pole Territoire Dakar'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ROUTE' and pole = 'Pole Territoire Dakar' ; Copy
1.17 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'SANTE' and pole = 'Pole Territoire Dakar'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'SANTE' and pole = 'Pole Territoire Dakar' ; Copy
1.17 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'JEUNESSE, SPORT, CULTURE ET LOISIRS' and pole = 'Pole Territoire Centre'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'JEUNESSE, SPORT, CULTURE ET LOISIRS' and pole = 'Pole Territoire Centre' ; Copy
1.13 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'COMMERCE ET ARTISANAT' and pole = 'Pole Territoire Dakar'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'COMMERCE ET ARTISANAT' and pole = 'Pole Territoire Dakar' ; Copy
1.13 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF' and pole = 'Pole Territoire Dakar'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF' and pole = 'Pole Territoire Dakar' ; Copy
1.12 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'AGRICULTURE , ELEVAGE ET PECHE' and pole = 'Pole Territoire Dakar'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'AGRICULTURE , ELEVAGE ET PECHE' and pole = 'Pole Territoire Dakar' ; Copy
1.12 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'EDUCATION ET FORMATION' and pole = 'Pole Territoire Dakar'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'EDUCATION ET FORMATION' and pole = 'Pole Territoire Dakar' ; Copy
1.11 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'HYDRAULIQUE' and pole = 'Pole Territoire Nord'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'HYDRAULIQUE' and pole = 'Pole Territoire Nord' ; Copy
1.11 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ROUTE' and pole = 'Pole Territoire Nord'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ROUTE' and pole = 'Pole Territoire Nord' ; Copy
1.10 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ENERGIE' and pole = 'Pole Territoire Thiès'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ENERGIE' and pole = 'Pole Territoire Thiès' ; Copy
1.10 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'JEUNESSE, SPORT, CULTURE ET LOISIRS' and pole = 'Pole Territoire Nord'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'JEUNESSE, SPORT, CULTURE ET LOISIRS' and pole = 'Pole Territoire Nord' ; Copy
1.10 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'HYDRAULIQUE' and pole = 'Pole Territoire Thiès'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'HYDRAULIQUE' and pole = 'Pole Territoire Thiès' ; Copy
1.10 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'AGRICULTURE , ELEVAGE ET PECHE' and pole = 'Pole Territoire Nord-Est'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'AGRICULTURE , ELEVAGE ET PECHE' and pole = 'Pole Territoire Nord-Est' ; Copy
1.10 ms
1
select secteur , COALESCE (SUM (CAST (cout AS BIGINT )), 0 ) AS total , couleur from dbo . realisations_secteur group by secteur , couleur
select secteur , COALESCE (SUM (CAST (cout AS BIGINT )), 0 ) AS total , couleur from dbo . realisations_secteur group by secteur , couleur ; Copy
1.09 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'COMMERCE ET ARTISANAT' and pole = 'Pole Territoire Thiès'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'COMMERCE ET ARTISANAT' and pole = 'Pole Territoire Thiès' ; Copy
1.09 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF' and pole = 'Pole Territoire Thiès'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF' and pole = 'Pole Territoire Thiès' ; Copy
1.09 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'EDUCATION ET FORMATION' and pole = 'Pole Territoire Thiès'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'EDUCATION ET FORMATION' and pole = 'Pole Territoire Thiès' ; Copy
1.08 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'AGRICULTURE , ELEVAGE ET PECHE' and pole = 'Pole Territoire Thiès'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'AGRICULTURE , ELEVAGE ET PECHE' and pole = 'Pole Territoire Thiès' ; Copy
1.08 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'COMMERCE ET ARTISANAT' and pole = 'Pole Territoire Nord'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'COMMERCE ET ARTISANAT' and pole = 'Pole Territoire Nord' ; Copy
1.08 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ENVIRONNEMENT ET ASSANISSEMENT' and pole = 'Pole Territoire Nord'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ENVIRONNEMENT ET ASSANISSEMENT' and pole = 'Pole Territoire Nord' ; Copy
1.07 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ENVIRONNEMENT ET ASSANISSEMENT' and pole = 'Pole Territoire Thiès'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ENVIRONNEMENT ET ASSANISSEMENT' and pole = 'Pole Territoire Thiès' ; Copy
1.07 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ROUTE' and pole = 'Pole Territoire Thiès'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ROUTE' and pole = 'Pole Territoire Thiès' ; Copy
1.07 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ROUTE' and pole = 'Pole Territoire Nord-Est'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ROUTE' and pole = 'Pole Territoire Nord-Est' ; Copy
1.07 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'SANTE' and pole = 'Pole Territoire Thiès'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'SANTE' and pole = 'Pole Territoire Thiès' ; Copy
1.07 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'COMMERCE ET ARTISANAT' and pole = 'Pole Territoire Nord-Est'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'COMMERCE ET ARTISANAT' and pole = 'Pole Territoire Nord-Est' ; Copy
1.07 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF' and pole = 'Pole Territoire Nord'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF' and pole = 'Pole Territoire Nord' ; Copy
1.07 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'SANTE' and pole = 'Pole Territoire Nord'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'SANTE' and pole = 'Pole Territoire Nord' ; Copy
1.07 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'EDUCATION ET FORMATION' and pole = 'Pole Territoire Nord'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'EDUCATION ET FORMATION' and pole = 'Pole Territoire Nord' ; Copy
1.07 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ENVIRONNEMENT ET ASSANISSEMENT' and pole = 'Pole Territoire Nord-Est'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ENVIRONNEMENT ET ASSANISSEMENT' and pole = 'Pole Territoire Nord-Est' ; Copy
1.07 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'HYDRAULIQUE' and pole = 'Pole Territoire Nord-Est'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'HYDRAULIQUE' and pole = 'Pole Territoire Nord-Est' ; Copy
1.06 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'JEUNESSE, SPORT, CULTURE ET LOISIRS' and pole = 'Pole Territoire Thiès'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'JEUNESSE, SPORT, CULTURE ET LOISIRS' and pole = 'Pole Territoire Thiès' ; Copy
1.06 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'AGRICULTURE , ELEVAGE ET PECHE' and pole = 'Pole Territoire Nord'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'AGRICULTURE , ELEVAGE ET PECHE' and pole = 'Pole Territoire Nord' ; Copy
1.06 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ENERGIE' and pole = 'Pole Territoire Nord-Est'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ENERGIE' and pole = 'Pole Territoire Nord-Est' ; Copy
1.06 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'EDUCATION ET FORMATION' and pole = 'Pole Territoire Nord-Est'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'EDUCATION ET FORMATION' and pole = 'Pole Territoire Nord-Est' ; Copy
1.06 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ENERGIE' and pole = 'Pole Territoire Nord'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'ENERGIE' and pole = 'Pole Territoire Nord' ; Copy
1.05 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'SANTE' and pole = 'Pole Territoire Nord-Est'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'SANTE' and pole = 'Pole Territoire Nord-Est' ; Copy
1.05 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'JEUNESSE, SPORT, CULTURE ET LOISIRS' and pole = 'Pole Territoire Nord-Est'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'JEUNESSE, SPORT, CULTURE ET LOISIRS' and pole = 'Pole Territoire Nord-Est' ; Copy
1.04 ms
1
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF' and pole = 'Pole Territoire Nord-Est'
select COALESCE (sum (cout ), 0 ) as montant from dbo . microprojet_secteur_pole where secteur = 'URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF' and pole = 'Pole Territoire Nord-Est' ; Copy
1.01 ms
2
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2022'
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2022' ; Copy
1.00 ms
1
select SUM (CAST (montant AS BIGINT )) AS total , year (signature ) as annee from dbo . seydifdl group by year (signature ) order by annee desc
select SUM (CAST (montant AS BIGINT )) AS total , year (signature ) as annee from dbo . seydifdl group by year (signature ) order by annee desc ; Copy
0.99 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'FATICK' and YEAR (date_signature )= '2023'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'FATICK' and YEAR (date_signature )= '2023' ; Copy
0.99 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'KAOLACK' and YEAR (date_signature )= '2023'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'KAOLACK' and YEAR (date_signature )= '2023' ; Copy
0.99 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'MATAM' and YEAR (date_signature )= '2023'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'MATAM' and YEAR (date_signature )= '2023' ; Copy
0.98 ms
1
select SUM (CAST (Montant AS BIGINT )) AS TotalMontant , count (region )as nombre from dbo . convention_region where region = 'LOUGA'
select SUM (CAST (Montant AS BIGINT )) AS TotalMontant , count (region )as nombre from dbo . convention_region where region = 'LOUGA' ; Copy
0.98 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'THIES' and YEAR (date_signature )= '2023'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'THIES' and YEAR (date_signature )= '2023' ; Copy
0.98 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'KAFFRINE' and YEAR (date_signature )= '2023'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'KAFFRINE' and YEAR (date_signature )= '2023' ; Copy
0.96 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'SEDHIOU' and YEAR (date_signature )= '2023'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'SEDHIOU' and YEAR (date_signature )= '2023' ; Copy
0.96 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'KOLDA' and YEAR (date_signature )= '2023'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'KOLDA' and YEAR (date_signature )= '2023' ; Copy
0.95 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'KEDOUGOU' and YEAR (date_signature )= '2023'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'KEDOUGOU' and YEAR (date_signature )= '2023' ; Copy
0.95 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'LOUGA' and YEAR (date_signature )= '2023'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'LOUGA' and YEAR (date_signature )= '2023' ; Copy
0.94 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'DIOURBEL' and YEAR (date_signature )= '2023'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'DIOURBEL' and YEAR (date_signature )= '2023' ; Copy
0.93 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'TAMBACOUNDA' and YEAR (date_signature )= '2026'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'TAMBACOUNDA' and YEAR (date_signature )= '2026' ; Copy
0.91 ms
1
SELECT t0 . id AS id_1 , t0 . pole AS pole_2 FROM pole t0 ORDER BY t0 . pole ASC
SELECT t0 . id AS id_1 , t0 . pole AS pole_2 FROM pole t0 ORDER BY t0 . pole ASC ; Copy
0.91 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'TAMBACOUNDA' and YEAR (date_signature )= '2023'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'TAMBACOUNDA' and YEAR (date_signature )= '2023' ; Copy
0.91 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'DAKAR' and YEAR (date_signature )= '2024'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'DAKAR' and YEAR (date_signature )= '2024' ; Copy
0.90 ms
2
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2023'
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2023' ; Copy
0.89 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'FATICK' and YEAR (date_signature )= '2024'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'FATICK' and YEAR (date_signature )= '2024' ; Copy
0.87 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'MATAM' and YEAR (date_signature )= '2024'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'MATAM' and YEAR (date_signature )= '2024' ; Copy
0.87 ms
2
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2021'
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2021' ; Copy
0.86 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'KEDOUGOU' and YEAR (date_signature )= '2024'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'KEDOUGOU' and YEAR (date_signature )= '2024' ; Copy
0.86 ms
2
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2018'
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2018' ; Copy
0.85 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'SAINT-LOUIS' and YEAR (date_signature )= '2023'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'SAINT-LOUIS' and YEAR (date_signature )= '2023' ; Copy
0.85 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'KAFFRINE' and YEAR (date_signature )= '2025'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'KAFFRINE' and YEAR (date_signature )= '2025' ; Copy
0.85 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'KEDOUGOU' and YEAR (date_signature )= '2026'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'KEDOUGOU' and YEAR (date_signature )= '2026' ; Copy
0.85 ms
2
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2024'
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2024' ; Copy
0.85 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'KEDOUGOU' and YEAR (date_signature )= '2025'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'KEDOUGOU' and YEAR (date_signature )= '2025' ; Copy
0.85 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'KAOLACK' and YEAR (date_signature )= '2026'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'KAOLACK' and YEAR (date_signature )= '2026' ; Copy
0.85 ms
2
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2025'
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2025' ; Copy
0.85 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'KOLDA' and YEAR (date_signature )= '2025'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'KOLDA' and YEAR (date_signature )= '2025' ; Copy
0.84 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'MATAM' and YEAR (date_signature )= '2025'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'MATAM' and YEAR (date_signature )= '2025' ; Copy
0.84 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'KAFFRINE' and YEAR (date_signature )= '2026'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'KAFFRINE' and YEAR (date_signature )= '2026' ; Copy
0.84 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'SEDHIOU' and YEAR (date_signature )= '2024'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'SEDHIOU' and YEAR (date_signature )= '2024' ; Copy
0.84 ms
2
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2019'
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2019' ; Copy
0.84 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'KOLDA' and YEAR (date_signature )= '2024'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'KOLDA' and YEAR (date_signature )= '2024' ; Copy
0.84 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'SEDHIOU' and YEAR (date_signature )= '2026'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'SEDHIOU' and YEAR (date_signature )= '2026' ; Copy
0.84 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'KAFFRINE' and YEAR (date_signature )= '2024'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'KAFFRINE' and YEAR (date_signature )= '2024' ; Copy
0.84 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'KAOLACK' and YEAR (date_signature )= '2024'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'KAOLACK' and YEAR (date_signature )= '2024' ; Copy
0.84 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'LOUGA' and YEAR (date_signature )= '2025'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'LOUGA' and YEAR (date_signature )= '2025' ; Copy
0.84 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'FATICK' and YEAR (date_signature )= '2025'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'FATICK' and YEAR (date_signature )= '2025' ; Copy
0.83 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'FATICK' and YEAR (date_signature )= '2026'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'FATICK' and YEAR (date_signature )= '2026' ; Copy
0.83 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'KOLDA' and YEAR (date_signature )= '2026'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'KOLDA' and YEAR (date_signature )= '2026' ; Copy
0.83 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'LOUGA' and YEAR (date_signature )= '2026'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'LOUGA' and YEAR (date_signature )= '2026' ; Copy
0.83 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'THIES' and YEAR (date_signature )= '2024'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'THIES' and YEAR (date_signature )= '2024' ; Copy
0.83 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'DIOURBEL' and YEAR (date_signature )= '2024'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'DIOURBEL' and YEAR (date_signature )= '2024' ; Copy
0.83 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'DIOURBEL' and YEAR (date_signature )= '2026'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'DIOURBEL' and YEAR (date_signature )= '2026' ; Copy
0.83 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'LOUGA' and YEAR (date_signature )= '2024'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'LOUGA' and YEAR (date_signature )= '2024' ; Copy
0.83 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'KAOLACK' and YEAR (date_signature )= '2025'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'KAOLACK' and YEAR (date_signature )= '2025' ; Copy
0.83 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'SEDHIOU' and YEAR (date_signature )= '2025'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'SEDHIOU' and YEAR (date_signature )= '2025' ; Copy
0.82 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'ZIGUINCHOR' and YEAR (date_signature )= '2023'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'ZIGUINCHOR' and YEAR (date_signature )= '2023' ; Copy
0.81 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'DAKAR' and YEAR (date_signature )= '2025'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'DAKAR' and YEAR (date_signature )= '2025' ; Copy
0.81 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'DIOURBEL' and YEAR (date_signature )= '2025'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'DIOURBEL' and YEAR (date_signature )= '2025' ; Copy
0.81 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'DAKAR' and YEAR (date_signature )= '2026'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'DAKAR' and YEAR (date_signature )= '2026' ; Copy
0.80 ms
2
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2020'
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2020' ; Copy
0.80 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'MATAM' and YEAR (date_signature )= '2026'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'MATAM' and YEAR (date_signature )= '2026' ; Copy
0.79 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'SAINT-LOUIS' and YEAR (date_signature )= '2026'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'SAINT-LOUIS' and YEAR (date_signature )= '2026' ; Copy
0.77 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'TAMBACOUNDA' and YEAR (date_signature )= '2024'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'TAMBACOUNDA' and YEAR (date_signature )= '2024' ; Copy
0.76 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'SAINT-LOUIS' and YEAR (date_signature )= '2025'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'SAINT-LOUIS' and YEAR (date_signature )= '2025' ; Copy
0.74 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'SAINT-LOUIS' and YEAR (date_signature )= '2024'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'SAINT-LOUIS' and YEAR (date_signature )= '2024' ; Copy
0.73 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'THIES' and YEAR (date_signature )= '2026'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'THIES' and YEAR (date_signature )= '2026' ; Copy
0.73 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'THIES' and YEAR (date_signature )= '2025'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'THIES' and YEAR (date_signature )= '2025' ; Copy
0.73 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'ZIGUINCHOR' and YEAR (date_signature )= '2026'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'ZIGUINCHOR' and YEAR (date_signature )= '2026' ; Copy
0.71 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'ZIGUINCHOR' and YEAR (date_signature )= '2025'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'ZIGUINCHOR' and YEAR (date_signature )= '2025' ; Copy
0.69 ms
1
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'ZIGUINCHOR' and YEAR (date_signature )= '2024'
select COALESCE (sum (montant ), 0 ) as montant from dbo . convention_pole where region = 'ZIGUINCHOR' and YEAR (date_signature )= '2024' ; Copy
0.64 ms
1
select SUM (CAST (Montant AS BIGINT )) AS TotalMontant , count (region )as nombre from dbo . convention_region where region = 'TAMBACOUNDA'
select SUM (CAST (Montant AS BIGINT )) AS TotalMontant , count (region )as nombre from dbo . convention_region where region = 'TAMBACOUNDA' ; Copy
0.62 ms
1
select SUM (CAST (Montant AS BIGINT )) AS TotalMontant , count (region )as nombre from dbo . convention_region where region = 'DIOURBEL'
select SUM (CAST (Montant AS BIGINT )) AS TotalMontant , count (region )as nombre from dbo . convention_region where region = 'DIOURBEL' ; Copy
0.61 ms
1
select SUM (CAST (Montant AS BIGINT )) AS TotalMontant , count (region )as nombre from dbo . convention_region where region = 'KAOLACK'
select SUM (CAST (Montant AS BIGINT )) AS TotalMontant , count (region )as nombre from dbo . convention_region where region = 'KAOLACK' ; Copy
0.59 ms
1
select SUM (CAST (Montant AS BIGINT )) AS TotalMontant , count (region )as nombre from dbo . convention_region where region = 'KOLDA'
select SUM (CAST (Montant AS BIGINT )) AS TotalMontant , count (region )as nombre from dbo . convention_region where region = 'KOLDA' ; Copy
0.55 ms
1
select SUM (CAST (Montant AS BIGINT )) AS TotalMontant , count (region )as nombre from dbo . convention_region where region = 'FATICK'
select SUM (CAST (Montant AS BIGINT )) AS TotalMontant , count (region )as nombre from dbo . convention_region where region = 'FATICK' ; Copy
0.54 ms
1
select SUM (CAST (Montant AS BIGINT )) AS TotalMontant , count (region )as nombre from dbo . convention_region where region = 'KAFFRINE'
select SUM (CAST (Montant AS BIGINT )) AS TotalMontant , count (region )as nombre from dbo . convention_region where region = 'KAFFRINE' ; Copy
0.53 ms
1
select SUM (CAST (montant AS BIGINT )) AS total from dbo . seydifdl
select SUM (CAST (montant AS BIGINT )) AS total from dbo . seydifdl ; Copy
0.53 ms
1
select SUM (CAST (Montant AS BIGINT )) AS TotalMontant , count (region )as nombre from dbo . convention_region where region = 'SAINT-LOUIS'
select SUM (CAST (Montant AS BIGINT )) AS TotalMontant , count (region )as nombre from dbo . convention_region where region = 'SAINT-LOUIS' ; Copy
0.53 ms
1
select SUM (CAST (Montant AS BIGINT )) AS TotalMontant , count (region )as nombre from dbo . convention_region where region = 'SEDHIOU'
select SUM (CAST (Montant AS BIGINT )) AS TotalMontant , count (region )as nombre from dbo . convention_region where region = 'SEDHIOU' ; Copy
0.53 ms
1
select SUM (CAST (Montant AS BIGINT )) AS TotalMontant , count (region )as nombre from dbo . convention_region where region = 'THIES'
select SUM (CAST (Montant AS BIGINT )) AS TotalMontant , count (region )as nombre from dbo . convention_region where region = 'THIES' ; Copy
0.51 ms
1
select SUM (CAST (Montant AS BIGINT )) AS TotalMontant , count (region )as nombre from dbo . convention_region where region = 'DAKAR'
select SUM (CAST (Montant AS BIGINT )) AS TotalMontant , count (region )as nombre from dbo . convention_region where region = 'DAKAR' ; Copy
0.47 ms
1
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2011'
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2011' ; Copy
0.47 ms
1
select SUM (CAST (Montant AS BIGINT )) AS TotalMontant , count (region )as nombre from dbo . convention_region where region = 'KEDOUGOU'
select SUM (CAST (Montant AS BIGINT )) AS TotalMontant , count (region )as nombre from dbo . convention_region where region = 'KEDOUGOU' ; Copy
0.45 ms
1
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2007'
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2007' ; Copy
0.44 ms
1
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2012'
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2012' ; Copy
0.44 ms
1
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2014'
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2014' ; Copy
0.44 ms
1
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2009'
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2009' ; Copy
0.44 ms
1
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2010'
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2010' ; Copy
0.44 ms
1
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2008'
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2008' ; Copy
0.44 ms
1
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2013'
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2013' ; Copy
0.44 ms
1
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2015'
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2015' ; Copy
0.43 ms
1
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2016'
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2016' ; Copy
0.42 ms
1
select SUM (CAST (Montant AS BIGINT )) AS TotalMontant , count (region )as nombre from dbo . convention_region where region = 'ZIGUINCHOR'
select SUM (CAST (Montant AS BIGINT )) AS TotalMontant , count (region )as nombre from dbo . convention_region where region = 'ZIGUINCHOR' ; Copy
0.42 ms
1
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2017'
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . seydifdl where YEAR (signature )= '2017' ; Copy
0.41 ms
1
select SUM (CAST (Montant AS BIGINT )) AS TotalMontant , count (region )as nombre from dbo . convention_region where region = 'MATAM'
select SUM (CAST (Montant AS BIGINT )) AS TotalMontant , count (region )as nombre from dbo . convention_region where region = 'MATAM' ; Copy
0.36 ms
1
SELECT t0 . id AS id_1 , t0 . communeb AS communeb_2 , t0 . cout AS cout_3 , t0 . secteurb AS secteurb_4 , t0 . libelle AS libelle_5 , t0 . demarrage AS demarrage_6 , t0 . latitude AS latitude_7 , t0 . longitude AS longitude_8 , t0 . geolocalisation AS geolocalisation_9 , t0 . georeferencement AS georeferencement_10 , t0 . cl_id AS cl_id_11 , t0 . generique_id AS generique_id_12 , t0 . convention_id AS convention_id_13 , t0 . secteur_id AS secteur_id_14 FROM realisations t0
SELECT t0 . id AS id_1 , t0 . communeb AS communeb_2 , t0 . cout AS cout_3 , t0 . secteurb AS secteurb_4 , t0 . libelle AS libelle_5 , t0 . demarrage AS demarrage_6 , t0 . latitude AS latitude_7 , t0 . longitude AS longitude_8 , t0 . geolocalisation AS geolocalisation_9 , t0 . georeferencement AS georeferencement_10 , t0 . cl_id AS cl_id_11 , t0 . generique_id AS generique_id_12 , t0 . convention_id AS convention_id_13 , t0 . secteur_id AS secteur_id_14 FROM realisations t0 ; Copy
0.31 ms
1
SELECT t0 . id AS id_1 , t0 . secteur AS secteur_2 , t0 . couleur AS couleur_3 , t0 . icone AS icone_4 , t0 . image AS image_5 FROM sectoriel t0 ORDER BY t0 . secteur ASC
SELECT t0 . id AS id_1 , t0 . secteur AS secteur_2 , t0 . couleur AS couleur_3 , t0 . icone AS icone_4 , t0 . image AS image_5 FROM sectoriel t0 ORDER BY t0 . secteur ASC ; Copy
0.25 ms
1
SELECT t0 . id AS id_1 , t0 . region AS region_2 , t0 . latitude AS latitude_3 , t0 . longitude AS longitude_4 , t0 . pole_id AS pole_id_5 FROM region t0 ORDER BY t0 . region ASC
SELECT t0 . id AS id_1 , t0 . region AS region_2 , t0 . latitude AS latitude_3 , t0 . longitude AS longitude_4 , t0 . pole_id AS pole_id_5 FROM region t0 ORDER BY t0 . region ASC ; Copy
0.22 ms
2
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2023
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2023 ; Copy
0.20 ms
2
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2021
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2021 ; Copy
0.19 ms
2
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2025
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2025 ; Copy
0.19 ms
2
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2019
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2019 ; Copy
0.19 ms
2
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2022
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2022 ; Copy
0.18 ms
2
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2024
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2024 ; Copy
0.18 ms
2
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2018
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2018 ; Copy
0.18 ms
2
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2020
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2020 ; Copy
0.17 ms
1
SELECT t0 . id AS id_1 , t0 . annee AS annee_2 , t0 . signature AS signature_3 , t0 . fichier AS fichier_4 , t0 . montant AS montant_5 , t0 . notification AS notification_6 , t0 . datenotification AS datenotification_7 , t0 . code AS code_8 , t0 . reference AS reference_9 , t0 . ct_id AS ct_id_10 , t0 . projet_id AS projet_id_11 FROM conventions t0
SELECT t0 . id AS id_1 , t0 . annee AS annee_2 , t0 . signature AS signature_3 , t0 . fichier AS fichier_4 , t0 . montant AS montant_5 , t0 . notification AS notification_6 , t0 . datenotification AS datenotification_7 , t0 . code AS code_8 , t0 . reference AS reference_9 , t0 . ct_id AS ct_id_10 , t0 . projet_id AS projet_id_11 FROM conventions t0 ; Copy
0.11 ms
1
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2012
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2012 ; Copy
0.11 ms
1
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2008
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2008 ; Copy
0.10 ms
1
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2016
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2016 ; Copy
0.10 ms
1
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2007
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2007 ; Copy
0.10 ms
1
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2010
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2010 ; Copy
0.09 ms
1
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2013
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2013 ; Copy
0.09 ms
1
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2014
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2014 ; Copy
0.09 ms
1
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2015
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2015 ; Copy
0.09 ms
1
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements ; Copy
0.09 ms
1
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2009
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2009 ; Copy
0.09 ms
1
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2011
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2011 ; Copy
0.09 ms
1
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2017
select COALESCE (SUM (CAST (montant AS BIGINT )), 0 ) AS total from dbo . engagements where annee = 2017 ; Copy