JAVA J2EE 4 U

 SELECT 

    d.name AS db_name,

    ROUND(AVG((bp.completion_time - bp.start_time) * 1440), 2) AS avg_full_backup_duration_mins,

    COUNT(*) AS full_backup_piece_count

FROM 

    rc_backup_set bs

JOIN 

    rc_backup_piece bp ON bs.set_stamp = bp.set_stamp AND bs.set_count = bp.set_count

JOIN 

    rc_database d ON bs.db_key = d.db_key

WHERE 

    bs.backup_type = 'D'  -- Full backup

    AND bp.start_time IS NOT NULL

    AND bp.completion_time IS NOT NULL

    AND bp.status = 'A'

    AND bp.start_time >= SYSDATE - 30

GROUP BY 

    d.name

ORDER BY 

    avg_full_backup_duration_mins DESC;