select Before050101=sum(case when date>'2005-01-01' then price else 0 end), After050101 =sum(case when date<'2005-01-01' then price else 0 end) from tb
select [Before050101] = sum(case when [date]>'2005-01-01' then price else 0 end) , [After050101] = sum(case when [date]<'2005-01-01' then price else 0 end) from 表名
After050101 =sum(case when date<'2005-01-01' then price else 0 end)
from tb
[Before050101] = sum(case when [date]>'2005-01-01' then price else 0 end) ,
[After050101] = sum(case when [date]<'2005-01-01' then price else 0 end)
from
表名