mysql> select count(*), sum(filesize), avg(filesize), max(filesize), min(filesize) from Cns_file_metadata where name like 'user08.MarcoMambelli.test.load.DPDfromFDR.081124.3171%log.tgz' order by name; +----------+---------------+---------------+---------------+---------------+ | count(*) | sum(filesize) | avg(filesize) | max(filesize) | min(filesize) | +----------+---------------+---------------+---------------+---------------+ | 21 | 4405822 | 209801.0476 | 221890 | 157875 | +----------+---------------+---------------+---------------+---------------+ mysql> select count(*), sum(filesize), avg(filesize), max(filesize), min(filesize) from Cns_file_metadata where name like 'user08.MarcoMambelli.test.load.DPDfromFDR.081124.3171%root' order by name; +----------+---------------+---------------+---------------+---------------+ | count(*) | sum(filesize) | avg(filesize) | max(filesize) | min(filesize) | +----------+---------------+---------------+---------------+---------------+ | 21 | 1323091082 | 63004337.2381 | 68803700 | 38371488 | +----------+---------------+---------------+---------------+---------------+