Total number of milliseconds for "pdfbox_1_8_8" by file extension

FILE_EXTENSION Elapsed Milliseconds A NUM_FILES Average Number of Milliseconds per File
pdf
64371712
231229
278.4




SELECT comparisons.FILE_EXTENSION, sum(ifnull(ELAPSED_TIME_MILLIS_A, 0)) as "Elapsed Milliseconds A", extensions_total.NUM_FILES as "Total Number of Files", DEC_PATTERN((1.0*sum(ifnull(ELAPSED_TIME_MILLIS_A, 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_A is null and SORT_STACK_TRACE_A is null group by comparisons.FILE_EXTENSION order by "Average Number of Milliseconds per File" desc;