Highest Peak Name and Elevation by Country

SELECT top (5)
      Sorted.CountryName AS [Country],
      CASE
          WHEN Sorted.PeakName IS NULL THEN '(no highest peak)'
          ELSE Sorted.PeakName
      END AS [Highest Peak Name],
      CASE
          WHEN Sorted.[Highest Peak Elevation] IS NULL THEN 0
          ELSE Sorted.[Highest Peak Elevation]
      END AS [Highest Peak Elevation],
      CASE
          WHEN Sorted.Mountain IS NULL THEN '(no mountain)'
          ELSE Sorted.Mountain
      END AS Mountain
      FROM (
           SELECT top 1000
                  c.CountryName AS [CountryName],
                  p.PeakName AS [PeakName],
                  MAX(p.Elevation) AS [Highest Peak Elevation],
                  m.MountainRange AS [Mountain],
                  DENSE_RANK() OVER (PARTITION BY CountryName ORDER BY MAX(p.Elevation) DESC) AS Rank
             FROM Countries AS c
             LEFT JOIN MountainsCountries AS mc
               ON c.CountryCode = mc.CountryCode
             LEFT JOIN Peaks AS p
               ON mc.MountainId = p.MountainId
             LEFT JOIN Mountains AS m
               ON p.MountainId = m.Id
            GROUP BY c.CountryName, p.PeakName, m.MountainRange
            ORDER BY CountryName, Rank
         )AS Sorted
 WHERE Sorted.Rank = 1