code:
select
a.row_owner,
max(b.full_name),
count(1) total_rows,
max(c.period_total) "6 MONTH UPDATES",
max(d.period_total) "12 MONTH UPDATES"
from
accounts a,
row_owner_table b,
(select count(owner_id) period_total, owner_id from accounts where last_update > ( sysdate - 180) group by owner_id ) c,
(select count(prd_ow_i) period_total, owner_id from accounts where last_update > ( sysdate - 360) group by owner_id ) d
where
b.id = a.row_owner and
d.owner_id (+) = a.owner_id and
c.owner_id (+) = a.owner_id
group by a.owner_id order by count(1) desc;