Number of Metadata Values per Content Type in "pdfbox_1_8_8"

DETECTED_CONTENT_TYPE_B	Total Number of Metadata Values	Total Number of Files	Average Number of Metadata Values per File
application/pdf	8,864,923	231,211	38
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_B as "Detected Content Type B", DEC_PATTERN(sum(ifnull(NUM_METADATA_VALUES_B, 0)), '###,###') as "Total Number of Metadata Values", DEC_PATTERN(detected_types_B.NUM_FILES, '###,###') as "Total Number of Files", DEC_PATTERN((1.0*sum(ifnull(NUM_METADATA_VALUES_B, 0))/detected_types_B.NUM_FILES), '###,###') as "Average Number of Metadata Values 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 order by sum(ifnull(NUM_METADATA_VALUES_B, 0)) desc;