This query finds the average of the prices of all titles, substituting the value “$10.00’’ for all NULL entries in price:
select avg(isnull(price,$10.00)) from titles
------------ 14.24 (1 row affected)
