Total number of milliseconds for "PDFBox_1_8_9-SNAPSHOT" by file extension

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




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;