select Defects_1.id,
case when Defects_1.status Not Like '4-Closed%' then (CURRENTDATE() - Defects_1.creation_time) As Defect_Age end
case when Defects_1.status Like '4-Closed%' then Defects_1.user_11as Defect_Age end
from Defects_1
Order By Defects_1.id

select Defects_1.id,
case when Defects_1.status Not Like '4-Closed%' then (CURRENTDATE() - Defects_1.creation_time) end As Defect_Age
case when Defects_1.status Like '4-Closed%' then Defects_1.user_11 end as Defect_Age
from Defects_1
Order By Defects_1.id