SELECT count(*) FROM addresses WHERE country  =  'USA'
How many addresses are there in country USA?
SELECT count ( * ) FROM addresses WHERE country = 'USA '
select count ( * ) from addresses where country = value
How many addresses are there in country USA ?