CREATE TABLE tbl (id int, company text, account text, amount int); INSERT INTO tbl VALUES (1, 'Coastal', 'A384', 500), (2, 'Coastal', 'C940', 200), (3, 'Coastal', 'Z934', 200), (4, 'American', 'U202', 200), (5, 'American', 'I034', 300), (6, 'Tester', 'P034', 50), -- added some rows (7, 'Tester', 'P034', 300), (8, 'Tester', 'P034', 50);

SELECT company , CASE WHEN sum(amount) >= 500 THEN json_agg(json_build_object(account, amount)) ELSE json_agg(json_build_object(account, amount)) FILTER (WHERE amount_rn = 1) END AS json_array , CASE WHEN sum(amount) >= 500 THEN array_agg((account, amount)) ELSE array_agg((account, amount)) FILTER (WHERE amount_rn = 1) END AS plain_array , CASE WHEN sum(amount) >= 500 THEN 'Met' ELSE 'Failed' END AS status FROM ( SELECT * , sum(amount) OVER (PARTITION BY company ORDER BY id ROWS BETWEEN UNBOUNDED PRECEDING AND 1 PRECEDING) AS running_sum , row_number() OVER (PARTITION BY company ORDER BY amount DESC NULLS LAST, id) AS amount_rn FROM tbl ORDER BY company, id ) sub WHERE running_sum >= 500 IS NOT TRUE GROUP BY 1;