~singpolyma/jmp-schemas

ref: 240b3444466fb458b517d84c83bd6a782a21934e jmp-schemas/deploy/balances.sql -rw-r--r-- 161 bytes
240b3444 — Stephen Paul Weber NOTIFY on low balance 1 year, 3 months ago 
                                                                                
a47fa130 Stephen Paul Weber 












2 years ago












1
2
3
4
5
6
7
8
9
10
11
12

-- Deploy jmp:balances to pg

BEGIN;

CREATE VIEW balances AS
	SELECT
		customer_id,
		SUM(amount) AS balance
	FROM transactions
	GROUP BY customer_id;

COMMIT;