CREATE MATERIALIZED VIEW materialized_view 
AS 
SELECT 
  a, 
  sum(b) AS sum_b 
FROM table 
GROUP BY a;