import duckdb rel = duckdb.sql('SELECT * FROM (VALUES (1, 4), (1, 2), (2, 3), (2, 4)) AS df(a, b)') result = rel.aggregate("sum(a) AS total_sum", "b > 1") print(result.df())