Select Code to Download

SELECT 
    report_no,
...
    to_char(date_reported,'DD-MON-YYYY'),
    cat1, cat2, cat3
compute avg(cat1), avg(cat2), avg(cat3)

my @sums;

$sums[$number] += $element;