Try this
select fa.new_contractid,AVG(Sum(vews.TransactionCount)) as BillableUsage from BingMapsPlatform_Staging.dbo.VEWSDailyAggTrans vews,BingMapsPlatform_MSCRM.dbo.FilteredAccount fa
where fa.new_accountid=vews.PrimaryId
and fa.new_contractid = '6145412166'
group by fa.new_contractid