SELECT count(*) AS COL3, SUM(TA2.refcount)
FROM ag_abortcode TA1, v_ag_hourlymaster TA2
WHERE TA1.abortcodeid=TA2.abortcodeid AND ( TA2.applianceid=1 )

SELECT count(*) AS COL3, SUM(TA2.refcount)
FROM ag_abortcode TA1, v_ag_hourlymaster TA2
WHERE TA1.abortcodeid=TA2.abortcodeid AND ( TA2.applianceid=1 )
GROUP BY TA1.abortcode, TA1.description

SELECT TA1.abortcode AS COL1, TA1.description AS COL2, SUM(TA2.refcount) AS COL3
FROM ag_abortcode TA1, v_ag_hourlymaster TA2
WHERE TA1.abortcodeid=TA2.abortcodeid AND ( TA2.applianceid=1 )
GROUP BY TA1.abortcode, TA1.description