Total attachments in "pdfbox_1_8_9_20150316" by file extension

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

SELECT comparisons.FILE_EXTENSION, sum(ifnull(NUM_ATTACHMENTS_B, 0)) as "Number of attachments total", extensions_total.NUM_FILES as TOTAL_FILES, DEC_PATTERN((1.0*sum(ifnull(NUM_ATTACHMENTS_B, 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 "Number of attachments total" > 0 order by "Number of attachments total" desc;