Collector Points Balance SQL

points_balance.sql

SELECT 
	(SELECT COALESCE(SUM(r.points_value), 0) FROM gc_promo_receipt r
	WHERE r.user_id = 1
	AND r.status = 'Approved')
-
	(SELECT COALESCE(SUM(l.reward_type_points_cost), 0) FROM gc_promo_user_reward_claim_ledger l
	INNER JOIN gc_promo_user_reward_claim c ON c.id = l.user_reward_claim_id
	WHERE c.redeemed_by_user_id = 1)
AS points_balance;