Show all the address information.
select * from addresses
How about those in country USA?
select * from addresses where country = 'USA'
How many of them are there?
select count(*) from addresses where country = 'USA'