How many countries in the North America Region has completed the vital registration?
has completed the vital registration refers to VitalRegistrationComplete = 'Yes'
SELECT COUNT(CountryCode) FROM Country WHERE VitalRegistrationComplete = 'Yes' AND Region = 'North America'