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;