Page Comparison

-- Attachment statistic
select p.pkey, p.pname, year(f.created) yr,
count(f.id) as "# of files", min(f.filesize)/1024 as "min size (kb)", avg(f.filesize)/1024 as "average size(kb)", max(f.filesize)/1024 as "max size(kb)", sum(f.filesize)/(1024*1024) as "total size(mb)"
from fileattachment f, project p, jiraissue i
WHERE f.issueid = i.id AND i.project = p.id
group by p.pkey, p.pname, yr;