GROUP BY and SUM in SQL Developer

Question

我需要计算三种产品在2010年的收入。这是我的疑问，我不明白出了什么问题我确信这些联接是正确的。

select p.product_de, c.year_de, sum(q.value) as sum_value
from products p
join quotas q
on p.product_id = q.product_id
join calendar_month c
on q.month_id = c.month_id
where p.product_de in('D - Product 7', 'D - Product 16', 'D - Product 1')
and c.year_de = '2010'
group by p.product_de, c.year_de, cus.customer_id

Answer 1

您只需要按查询的列进行分组。也没有加入表cus

尝试；

select p.product_de, c.year_de, sum(q.value) as sum_value
from products p
join quotas q
on p.product_id = q.product_id
join calendar_month c
on q.month_id = c.month_id
where p.product_de in('D - Product 7', 'D - Product 16', 'D - Product 1')
and c.year_de = '2010'
group by p.product_de, c.year_de;