GROUP BY must contain all fields
Select course,subject,held,course_date,idtraining,course,
count(training.course)
from training
group by
course,subject,held,course_date,idtraining,training.course
order by training.course