Total attachments in "PDFBox_1_8_9_20150316_single_thread" by file extension

FILE_EXTENSION	Number of attachments total	NUM_FILES	Average number of attachments per file
pdf	7312	231229	0

SELECT comparisons.FILE_EXTENSION, sum(ifnull(NUM_ATTACHMENTS_A, 0)) as "Number of attachments total", extensions_total.NUM_FILES as "Total number of files", DEC_PATTERN( (1.0*sum(ifnull(NUM_ATTACHMENTS_A, 0))/extensions_total.NUM_FILES), '###,###.#')as "Average number of attachments per file" from comparisons left outer join extensions_total on comparisons.FILE_EXTENSION=extensions_total.FILE_EXTENSION group by comparisons.FILE_EXTENSION having "Total number of files" > 0 order by "Total number of files" desc;