SQL:
select g.registertime,
decode(sum(inner), null, 0, sum(inner)) inner,
decode(sum(outer), null, 0, sum(outer)) outer
from(
SELECT t.registertime,
case WHEN t.card_belong='inner' then t.addinnermembercount
END as inner,
case WHEN t.card_belong='outer' then t.addinnermembercount
END as outer
FROM temp_ t
group by t.registertime,t.card_belong,t.addinnermembercount
)g
group by g.registertime
select g.registertime,
decode(sum(inner), null, 0, sum(inner)) inner,
decode(sum(outer), null, 0, sum(outer)) outer
from(
SELECT t.registertime,
case WHEN t.card_belong='inner' then t.addinnermembercount
END as inner,
case WHEN t.card_belong='outer' then t.addinnermembercount
END as outer
FROM temp_ t
group by t.registertime,t.card_belong,t.addinnermembercount
)g
group by g.registertime