This topic is locked

graph problem

9/19/2017 11:07:10 AM
PHPRunner General questions
H
htmalbenur author

hi is the code sql to have the graph but it does not work as i hope, i ask for your help please, how can i arrange the sql codes to have proper graphs
SELECT

Sexe,

COUNT(Sexe) AS Total,

YEAR(Date de remplissage) AS Année,

MONTHNAME(Date de remplissage) AS Mois

FROM fn_nord

WHERE (Sexe ='Masculin' OR Sexe ='Féminin')

GROUP BY Sexe, YEAR(Date de remplissage), MONTHNAME(Date de remplissage)
https://ibb.co/bUY3jQ

https://ibb.co/fKULW5

https://ibb.co/jRacB5
thx