UPDATE orders SET total = price * quantity WHERE id = 1;

CREATE TABLE orders (
    id INT PRIMARY KEY,
    price DECIMAL(10,2),
    quantity INT,
    total DECIMAL(10,2) GENERATED ALWAYS AS (price * quantity) STORED
);

WITH RECURSIVE numbers AS (
    SELECT 1 AS n  
    UNION ALL  
    SELECT n + 1 FROM numbers WHERE n < 100  
)  
SELECT * FROM numbers;

SELECT 
    user_id, 
    transaction_date, 
    amount, 
    SUM(amount) OVER (
        PARTITION BY user_id 
        ORDER BY transaction_date 
        RANGE BETWEEN INTERVAL '7 days' PRECEDING AND CURRENT ROW
    ) AS rolling_sum
FROM transactions;