Query alias as di SQL Server

Assalam, coba seperti ini mas :
select dateadd(day,cast(jumlah as numeric(18,0)),tglbaru) AS Tanggal,datediff(day,dateadd(day,cast(jumlah as numeric(18,0)),tglbaru),GETDATE()) as total

oke gan, solved mas 
 
tapi kalow saya mo tamabahin case when  gmana yak.
ane tambahin lagi field tablenya gan
 
Tablenya
 
Jumlah      Tanggalbaru    Harga
1                 2017-04-10       10.000
3                 2017-04-10      20.000
 
select dateadd(day,cast(jumlah as numeric(18,0)),tglbaru) AS Tanggal,datediff(day,dateadd(day,cast(jumlah as numeric(18,0)),tglbaru),GETDATE()) as total,
case when total<=0 then harga
end as totalharga,
case when total>0 then harga
end as totalharga2
 
hasilnya error
Hasilnya error karena coloumn =>total<= tidak ada ditable
Invalid column name 'total'
FROM table
 
Makasih banyak gan...
 

Assalam, Jadinya gini mas : 
select dateadd(day,cast(jumlah as numeric(18,0)),tglbaru) AS Tanggal,datediff(day,dateadd(day,cast(jumlah as numeric(18,0)),tglbaru),GETDATE()) as total,
case when datediff(day,dateadd(day,cast(jumlah as numeric(18,0)),tglbaru),GETDATE())<=0 then harga
end as totalharga,
case when datediff(day,dateadd(day,cast(jumlah as numeric(18,0)),tglbaru),GETDATE())>0 then harga
end as totalharga2

sudah ane coba gan, solved
 
nah yang jadi pertanyaan kalow saya cari query sebagai berikut :
where totalharga=10000
 
Hasilnya error karena coloumn =>Totalharga<= tidak ada ditable
Invalid column name 'totalharga'
 
itu gmana gan carana ?
ane udah coba  query na
where 
case when datediff(day,dateadd(day,cast(jumlah as numeric(18,0)),tglbaru),GETDATE())<=0 then harga
end as totalharga=10000
 
Terima kasih