Unanswered: group function error
can anyone please help me with my query.
i have a table with a assessment_type column,
case when assessment_type = 'assignment' then format(sum(q.grades)/count(a.assessment_code),2) else 0 end as 'Assignment Grade',
case when assessment_type = 'project' then format(sum(q.grades)/count(a.assessment_code),2) else 0 end as 'Project Grade'
FROM insert_grades as q
inner join upload_assessment as a
on (q.assessment_id = a.idassessment)
where q.last_name = 'cruz'
there are project, assignment in assessment_type column
i want to separate them in another column
it makes another column for each assessment type but it into another NEW ROW!
it should be in 1 row.
assignment grades | project grades
i think it is in groupings, but i cant fix it.
please see attached image file
can anyone please.
Last edited by homer.favenir; 09-17-08 at 05:10.
Take Nothing But Pictures;
Leave Nothing But Footprints;
Kill Nothing But Time;