Using the AdventureWorks database this query gives 3 rows.
select count(addressline1) from person.address
where addressline1='1970 Napa Ct.'
group by addressline1
Suppose I change addressline1 from '1970 Napa Ct.' to 'xxx'. It will return nothing.
How can I amend the query to return a number zero if the address does not exist?