This will return the average condition rating of all equipment grouped per class and criticality of that equipment. Equipment must have class and criticality and condition rating calculated for it to be included. And to keep it simpler the query is not language independent.
SELECT * FROM (
SELECT cls_desc||' ('||obj_class||')' Class,
obj_criticality criticality,
ROUND( AVG( obj_conditionrating )) avgconditionrating
FROM r5objects, r5classes
WHERE obj_class = cls_code
AND obj_class_org = cls_org
AND obj_criticality IS NOT NULL
AND obj_conditionrating IS NOT NULL
GROUP BY obj_class, obj_class_org, cls_desc, obj_criticality
HAVING ROUND( AVG( obj_conditionrating ) ) > -1 )
PIVOT ( AVG( avgconditionrating )
FOR criticality IN
( 'CRIT01' "Very Low", 'CRIT02' "Low", 'CRIT03' "Medium",
'CRIT04' "High", 'CRIT05' "Critical" ) )
ORDER BY 1