Page History

SELECT
    COUNT(*) AS num_attachments,
    AVG(CAST(ao.FILE_SIZE AS FLOAT) / 1048576)) AS avg_filesize_Mb,
    SUM(CAST(ao.FILE_SIZE AS FLOAT) / 1048576)) AS total_filesize_Mb,
    p.pname,
    p.pkey
FROM
    project p
JOIN
    jiraissue j ON p.id = j.project
JOIN
    AO_8B1069_ATTACHMENT ao ON ao.ISSUE_ID = j.id
GROUP BY
    p.pkey,
    p.pname;

SELECT
    ao.FILE_NAME,
      CAST(ao.FILE_SIZE AS FLOAT) / 1048576 AS filesize_Mb,
    p.pname,
    p.pkey
FROM
    project p
JOIN
    jiraissue j ON p.id = j.project
JOIN
    AO_8B1069_ATTACHMENT ao ON ao.ISSUE_ID = j.id;