I have two queries that returns the total number of issuances and redemptions from two different tables.
This one returns issuances, around 18k
select count(*) from issuances_extended WHERE status = 'completed'
This one returns redemptions, around 7k
select count(*) from redemptions_extended WHERE status = 'completed'
I need the sum of them, I came up with this but this only returns 2, counting it wrong
with active_user as ( select count(*) as issuance_count from issuances_extended where status = 'completed' UNION ALL select count(*) as redemption_count from redemptions_extended where status = 'completed' ) select count(*) from active_user
What should I do?
Advertisement
Answer
select (select count(*) from issuances_extended WHERE status = 'completed') + (select count(*) from redemptions_extended WHERE status = 'completed') AS result