Total attachments in "pdfbox_1_8_9_20150316" by detected content type

DETECTED_CONTENT_TYPE_B	Number of attachments total	NUM_FILES	Average number of attachments per file
application/pdf	7312	231211	0.03

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