Average of datedifference

[Lars Röttiger]

Hi All,

I have a big problem. Google couldn't really help. To understand my problem: I need to get the average time(in minutes) betwwen a bug was created and the bug was closed. I need that for every product and its components, severity and priotity. Maybe someone can help to rescue my weekend;) Thanks a lot

SQL:
select p.name,c.name , b.priority, b.bug_severity,count(1) as Count,
avg(ROUND((UNIX_TIMESTAMP(max(ba.bug_when)) - UNIX_TIMESTAMP(b.creation_ts)) / 60, 0))
from bugs b
inner join components c on c.id = b.component_id
inner join products p on p.id = b.product_id
inner join bugs_activity ba on ba.bug_id = b.bug_id
where 1=1
and b.bug_status = 'CLOSED'
GROUP BY c.name,p.name, b.priority,b.bug_severity;

Error:
Error Code : 1111
Invalid use of group function