Postgres | Per Ipp Amount Totals in Only The Top Programs

postgre_amounts_in_top_programs.sql

WITH all_ipp AS (
	SELECT program_id, SUM(total_amount_eqv) AS total_amount
	FROM pdg.ipp
	GROUP BY program_id
), top_ipp AS (
	SELECT program_id
	FROM all_ipp
	WHERE total_amount > (SELECT SUM(total_amount)/10 FROM all_ipp)
)
SELECT 
  program_id,
  program_name,
  SUM(total_amount_eqv) AS product_sales
FROM pdg.ipp
WHERE program_id IN (SELECT program_id FROM top_ipp)
GROUP BY program_id, program_name;