Number of metadata values per content type in "pdfbox_1_8_8"

DETECTED_CONTENT_TYPE_A	NUM_METADATA_VALUES_TOTAL	NUM_FILES	Average number of metadata values per file
application/pdf	8864920	231211	38.34
text/plain; charset=windows-1252	110	11	10
text/plain; charset=windows-1255	30	3	10
text/plain; charset=ISO-8859-1	20	2	10
text/html; charset=ISO-8859-1	12	1	12
text/plain; charset=ISO-8859-8	10	1	10

SELECT comparisons.detected_content_type_A, sum(ifnull(NUM_METADATA_VALUES_A, 0)) as NUM_METADATA_VALUES_TOTAL, detected_types_A.NUM_FILES as TOTAL_FILES, DEC_PATTERN((1.0*sum(ifnull(NUM_METADATA_VALUES_A, 0))/detected_types_A.NUM_FILES), '#.##' ) as "Average number of metadata values per file" from comparisons left outer join detected_types_A on comparisons.detected_content_type_A=detected_types_A.DETECTED_CONTENT_TYPE_A group by comparisons.DETECTED_CONTENT_TYPE_A order by NUM_METADATA_VALUES_TOTAL desc;