DELIMITER $$

DROP PROCEDURE IF EXISTS `sp_select_cities_by_nation` $$

CREATE PROCEDURE `sp_select_cities_by_nation`()
BEGIN
             SELECT d.Name as Nation,c.Name,c.Population
             FROM world.city c, world.country d
             WHERE c.CountryCode = d.Code AND d.name='United Kingdom';
END $$

DELIMITER ;
demo