Total number of milliseconds for "pdfbox_1_8_9_20150316" by file extension

FILE_EXTENSION Elapsed Time(Millis) B NUM_FILES Average Number of Milliseconds per File
pdf
64068571
231229
277.1




SELECT comparisons.FILE_EXTENSION, sum(ifnull(ELAPSED_TIME_MILLIS_B, 0)) as "Elapsed Time(Millis) B", extensions_total.NUM_FILES as TOTAL_FILES, DEC_PATTERN((1.0*sum(ifnull(ELAPSED_TIME_MILLIS_B, 0))/extensions_total.NUM_FILES), '###,###.#') as "Average Number of Milliseconds per File" from comparisons left outer join extensions_total on comparisons.FILE_EXTENSION=extensions_total.FILE_EXTENSION where JSON_EX_B is null and SORT_STACK_TRACE_B is null group by comparisons.FILE_EXTENSION order by "Average Number of Milliseconds per File" desc;