CREATE TABLE payments (
  payment_id BIGINT,
  customer_id BIGINT,
  payment_time TIMESTAMP,
  amount DECIMAL(12, 2),
  payment_method VARCHAR
);

CREATE VIEW bm06_customer_payment_windows AS
SELECT
  customer_id,
  payment_time,
  amount,
  ROW_NUMBER() OVER (PARTITION BY customer_id ORDER BY payment_time) AS payment_number,
  LAG(amount) OVER (PARTITION BY customer_id ORDER BY payment_time) AS previous_amount,
  SUM(amount) OVER (
    PARTITION BY customer_id
    ORDER BY payment_time
    ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
  ) AS running_amount
FROM payments

error: Not yet implemented Multiple RANK aggregates per window
 You can suggest support for this feature by filing an issue at https://github.com/feldera/feldera/issues
 14| ROW_NUMBER() OVER (PARTITION BY customer_id ORDER BY payment_time) AS payment_number,
     ^^^^^^^^^^^^
 15| LAG(amount) OVER (PARTITION BY customer_id ORDER BY payment_time) AS previous_amount