我写了一条sql语句查询northwind数据库一年每个季度的销售情况，可是结果每年每季度的结果都是一样的selectyear(ShippedDate)as年份,第一季度=(selectsum(UnitPrice*Quantity*(1-Discount))fromOrders,[Ord

Question

我写了一条sql语句查询northwind数据库一年每个季度的销售情况，可是结果每年每季度的结果都是一样的
select year(ShippedDate) as 年份,
第一季度=(select sum(UnitPrice*Quantity*(1-Discount))
from Orders,[Order Details]
where Orders.OrderID=[Order Details].OrderID
and month(ShippedDate) in (1,2,3)) ,
第二季度=(select sum(UnitPrice*Quantity*(1-Discount))
from Orders,[Order Details]
where Orders.OrderID=[Order Details].OrderID
and month(ShippedDate) in (4,5,6)),
第三季度=(select sum(UnitPrice*Quantity*(1-Discount))
from Orders,[Order Details]
where Orders.OrderID=[Order Details].OrderID
and month(ShippedDate) in (7,8,9)),
第四季度=(select sum(UnitPrice*Quantity*(1-Discount))
from Orders,[Order Details]
where Orders.OrderID=[Order Details].OrderID
and month(ShippedDate) in (10,11,12))
from Orders,[Order Details]
where year(ShippedDate) is not null
group by year(ShippedDate)
order by year(ShippedDate)
麻烦帮改下

Answer 1

可以简要说下表Orders ， [Order Details] 的字段和关系吗？