The Cloud Database for
Fast-Changing Data.

1CREATE MATERIALIZED VIEW my_view AS
2  SELECT userid, COUNT(api.id), COUNT(pageviews.id)
3  FROM users
4  JOIN pageviews on users.id = pageviews.userid
5  JOIN api ON users.id = api.userId
6  GROUP BY userid;

1CREATE MATERIALIZED VIEW my_window AS
2  SELECT date_trunc('minute', received_at),
3  COUNT(*) as order_ct, SUM(amount) as revenue
4  FROM orders
5  WHERE mz_now() < received_at + interval '5 minutes'
6  GROUP BY 1;

1SELECT userID, email, MAX(orders.id) as last_order
2FROM users
3JOIN orders ON orders.userID = users.id
4GROUP BY userId, email
5-- Use a filter to surface users with a high % of fraud
6HAVING SUM(is_fraud) / COUNT(orders.id)::FLOAT > 0.5;