带条件的ARRAY_SUM

def conditional_array_sum(arr, condition):
    return sum(x for x in arr if condition(x))

# 示例使用
data = [1, 2, 3, 4, 5]
result = conditional_array_sum(data, lambda x: x % 2 == 0)  # 只对偶数求和
print(result)  # 输出: 6 (2 + 4)

function conditionalArraySum(arr, condition) {
    return arr.reduce((acc, x) => condition(x) ? acc + x : acc, 0);
}

// 示例使用
const data = [1, 2, 3, 4, 5];
const result = conditionalArraySum(data, x => x % 2 === 0);  // 只对偶数求和
console.log(result);  // 输出: 6 (2 + 4)

SELECT SUM(column_name) AS sum_value
FROM table_name
WHERE condition;

SELECT SUM(sales) AS total_sales
FROM sales_data
WHERE date >= '2023-01-01' AND date <= '2023-12-31';

def conditional_array_sum(arr, condition):
    return sum(float(x) for x in arr if condition(x))  # 确保所有元素转换为浮点数