How many breweries are located in North America?
North America refers to country = 'United States'; North America is the name of continent where country = 'United States' is located;
SELECT COUNT(BrandID) FROM rootbeerbrand WHERE Country = 'United States'