Question: Test Feedback: DELIMITER / / CREATE FUNCTION DRIVER _ STATUS ( driver _ id INT ) RETURNS VARCHAR ( 1 0 ) DETERMINISTIC BEGIN DECLARE
Test Feedback:
DELIMITER
CREATE FUNCTION DRIVERSTATUSdriverid INT RETURNS VARCHAR
DETERMINISTIC
BEGIN
DECLARE TRAVELCOUNT INT DEFAULT ;
DECLARE DRIVERLEVEL VARCHAR;
SELECT COUNT INTO TRAVELCOUNT
FROM TRAVELS
WHERE DRIVERID driverid;
IF TRAVELCOUNT THEN
SET DRIVERLEVEL 'MASTER';
ELSEIF TRAVELCOUNT THEN
SET DRIVERLEVEL 'PRO';
ELSE
SET DRIVERLEVEL 'ROOKIE';
END IF;
RETURN DRIVERLEVEL;
END
DELIMITER;
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
