How many of the countries name start with alphabet A? List down the Alpha2Code of them.
countries name starts with alphabet A refers to shortname like 'A%';
SELECT COUNT(ShortName) FROM Country WHERE ShortName LIKE 'A%' UNION SELECT alpha2code FROM country WHERE shortname LIKE 'A%'