| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/MichaelMalz/CST1602/Resources/Week/11/ |
Upload File : |
DROP FUNCTION IF EXISTS CustomerLevel;
DELIMITER $$
CREATE FUNCTION CustomerLevel(
credit DECIMAL(10,2)
)
RETURNS VARCHAR(20)
DETERMINISTIC
BEGIN
DECLARE customerLevel VARCHAR(20);
IF credit > 50000 THEN
SET customerLevel = 'PLATINUM';
ELSEIF (credit <= 50000 AND credit >= 15000) THEN
SET customerLevel = 'GOLD';
ELSEIF credit < 15000 AND credit > 0 THEN
SET customerLevel = 'SILVER';
ELSE
SET customerLevel = 'LEAD';
END IF;
-- return the customer level
RETURN (customerLevel);
END$$
DELIMITER ;