Commission
Concours

Classement annuel Challenge THF 2019

Erreur SQL !SELECT indicatif, dept, sum(tqso) as stations, sum(tdpt) as dpt, sum(tloc) as loc, sum(tpts) as pts FROM challenge_score WHERE annee='2019' AND bande='144M' AND tpts >0 GROUP BY indicatif ORDER by pts DESC
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'concours.challenge_score.dept' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by