mysql查询季度都是1_我写了一条sql语句查询northwind数据库一年每个季度的销售情况，可是结果每年每季度的结果都是一样的...

select year(ShippedDate) as 年份,

sum

(

case when

Orders.OrderID=[Order Details].OrderID and month(ShippedDate) in (1,2,3))

then UnitPrice*Quantity*(1-Discount)

else 0

) as 第一季度,

sum

(

case when

Orders.OrderID=[Order Details].OrderID and month(ShippedDate) in (4,5,6))

then UnitPrice*Quantity*(1-Discount)

else 0

) as 第二季度,

sum

(

case when

Orders.OrderID=[Order Details].OrderID and month(ShippedDate) in (7,8,9))

then UnitPrice*Quantity*(1-Discount)

else 0

) as 第三季度,

sum

(

case when

Orders.OrderID=[Order Details].OrderID and month(ShippedDate) in (10,11,12))

then UnitPrice*Quantity*(1-Discount)

else 0

) as 第四季度

from Orders,[Order Details]

where year(ShippedDate) is not null

group by year(ShippedDate)

order by year(ShippedDate)

试下这个