MySQL / PostgreSQL
Code Block |
---|
-- Find Attachment statisticStatistic selectSELECT p.pkey, p.pname, yearEXTRACT(YEAR FROM f.created) yr, countCOUNT(f.id) asAS "# of files", minMIN(f.filesize)/1024 asAS "min size (kb)", avgAVG(f.filesize)/1024 asAS "average size(kb)", maxMAX(f.filesize)/1024 asAS "max size(kb)", sumSUM(f.filesize)/(1024*1024) asAS "total size(mb)" fromFROM fileattachment f, project p, jiraissue i WHERE f.issueid = i.id AND i.project = p.id groupGROUP byBY p.pkey, p.pname, yr; |