text: SELECT c.CountryCode,
  	   COUNT(mc.MountainId) AS MountainRanges
  FROM Countries AS c
  LEFT JOIN MountainsCountries AS mc
  ON c.CountryCode = mc.CountryCode
  WHERE c.CountryCode IN ('BG', 'RU', 'US')
  GROUP BY c.CountryCode