you can try

avg(isnull(age,0))

That is what exactly I was doing - getting the cost, and storing in temp table for each tid. But I want to avoid the use of temp table as...

COST(TID) is a bunch of select statements from different tables based on the value of tid. I can use union of all those select statements and write a single query,...