sql query

/****** Script for SelectTopNRows command from SSMS  ******/
SELECT c.CountryName, r.RiverName
  FROM [Geography].[dbo].[CountriesRivers] cr
  JOIN Countries c ON cr.CountryCode = c.CountryCode
  JOIN Rivers r ON cr.RiverId = r.Id
  WHERE c.CountryName = 'Brazil' OR c.CountryName = 'Mexico'/*
                                   OR c.CountryName = 'Austria' */
  ORDER BY r.RiverName