cds视图中的子查询总和

SELECT SUM(subquery_sum) as total_sum
FROM (
    SELECT column_name * quantity as subquery_sum
    FROM your_table
) as subquery_table;

-- 假设我们有一个名为"sales"的表，包含"price"和"quantity"列
SELECT SUM(subquery_sum) as total_revenue
FROM (
    SELECT price * quantity as subquery_sum
    FROM sales
) as subquery_table;