USE SPRINGFIELD;

DROP FUNCTION IF EXISTS comparar_numeros;

DELIMITER $$

CREATE FUNCTION comparar_numeros(n INT, m INT)
	RETURNS VARCHAR(20)
    
    BEGIN
		DECLARE s VARCHAR(20);
        
        IF n>m THEN SET s='>';
        ELSEIF n=m THEN SET s='=';
        ELSE SET s='<';
        END IF;
        
        SET s = CONCAT(n, ' ', s, ' ',m);
        
        RETURN s;
	END;$$
    
DELIMITER ;


DROP FUNCTION IF EXISTS comparar_numeros2;

DELIMITER $$

CREATE FUNCTION comparar_numeros2(n INT, m INT)
	RETURNS VARCHAR(50)
    
    BEGIN
		DECLARE s VARCHAR(50);
        
        IF n=m THEN SET s='iguales';
        ELSE 
			IF n>m THEN SET s='mayor que';
            ELSE SET s='menor que';
            END IF;
            
            SET s=CONCAT('es ',s);
        END IF;
        
        SET s = CONCAT(n, ' ', s, ' ',m);
        
        RETURN s;
	END;$$
    
DELIMITER ;

DROP FUNCTION IF EXISTS cuenta_atras;

DELIMITER $$

CREATE FUNCTION cuenta_atras(n INT)
	RETURNS INT
    
    BEGIN
		DECLARE i INT;
        SET i=n;
		label1: WHILE i>0 DO
			SET i=i-1;       
		END WHILE label1;
        RETURN i;
	END;$$
    
DELIMITER ;


DROP FUNCTION IF EXISTS cuenta_atras2;

DELIMITER $$

CREATE FUNCTION cuenta_atras2(n INT)
	RETURNS INT
    
    BEGIN
		DECLARE i INT;
        DECLARE cont INT;
        SET i=n;
        SET cont=0;
		label1: WHILE i>0 DO
			SET i=i-1; 
            SET cont=cont+1;
		END WHILE label1;
        RETURN cont;
	END;$$
    
DELIMITER ;
    

DROP FUNCTION IF EXISTS cuenta_adelante;

DELIMITER $$

CREATE FUNCTION cuenta_adelante(n INT)
RETURNS INT

BEGIN

	DECLARE i INT;
    
    SET i=0;
    
    label1: LOOP
		SET i=i+n;
        IF i<3000 THEN
			ITERATE label1;
		END IF;
        LEAVE label1;
	END LOOP label1;
    
    RETURN i;

END;$$

DELIMITER ;

DROP PROCEDURE IF EXISTS cuenta_adelante2;

DELIMITER $$

CREATE PROCEDURE cuenta_adelante2(n INT)
BEGIN
    SET @i=0;
    REPEAT
		SET @i=@i+1;
	UNTIL @i>n END REPEAT;
END;$$

DELIMITER ;