13. Rivers in Africa

SELECT c.country_name,
       r.river_name
FROM countries c
LEFT JOIN countries_rivers ON c.country_code = countries_rivers.country_code
LEFT JOIN rivers r ON countries_rivers.river_id = r.id
WHERE c.continent_code = (SELECT con.continent_code from continents con WHERE con.continent_name ='Africa')
ORDER BY c.country_name
LIMIT 5