Task 2:The Driver Relationship team wants to arrange workshops and education materials to the drivers. However, the team wants to create clusters of the drivers based on their experience in InstantStay. To collect these detail, you will need to create a SQL function called DRIVER_STATUS to determine the level of the driver as follows:MASTER: more than 4 travelsPRO: more than 2 travelsROOKIE: 2 or less travelsIn addition, run the function to verify it works as expected and send them back the driver levels.Task: Create the DRIVER_STATUS function to create clusters of drivers based on experience. THIS CODE YOU SEE HERE IS WRONG. THERE IS AN ERROR AT LINE 2DELIMITER <CREATE FUNCTION DRIVER_STATUS(int DRIVERID)RETURNS VARCHARBEGINDECLARE //to store number of travelsCount int;//to store levelLevel VARCHAR; //Selects according to passed valueSELECT COUNT(*) INTO Level FROM TRAVEL WHERE DRIVER_ID = DRIVERID;//returns levelIF( Count > 4) THEN RETURN "MASTER";ELSE IF (Count > 2) THEN RETURN "PRO"ELSE IF (Count <= 2) THEN RETURN "ROOKIE"; ENDDELIMITER ; DRIVER_IDDRIVER_FIRST_NAME DRIVER_LAST_NAME DRIVER_DRIVING_LICENSE_IDDRIVER_START_DATE DRIVER_DRIVING_LICENSE_CHECKEDDRIVER_RATING2001WillieButler18745012019-09-1214.42002JustinHoward19538532019-09-0914.82003AnthonyWalker17354872019-09-1513.52004EceYilmaz17347472019-08-151 Instructions Page 2 of 4+query.sql1 THIS CODE YOU SEE HERE IS WRONG. THERE IS AN ERROR AT LINE 23 DELIMITER <Task 2:4 CREATE FUNCTION DRIVER_STATUS(int DRIVERID)5 RETURNS VARCHARThe Driver Relationship team wants to arrange workshops and education materials to the6drivers. However, the team wants to create clusters of the drivers based on their7 BEGIN8 DECLAREexperience in InstantStay. To collect these detail, you will need to create a SQL function9 //to store number of travelscalled DRIVER_STATUS to determine the level of the driver as follows:10 Count int;11 //to store level• MASTER: more than 4 travels12 Level VARCHAR;13• PRO: more than 2 travels| 14 //Selects according to passed value15 SELECT COUNT (*) INT0 Level FROM TRAVEL WHERE DRIVER_ID = DRIVERID;• ROOKIE: 2 or less travels1617 //returns level|18 IF( Count > 4) THENIn addition, run the function to verify it works as expected and send them back the driverlevels.DETUDAL IMAS TEDIL.Task9 SQL Viewer+Create the DRIVER_STATUS function to create clusters of drivers based onexperience.0.00out of10.00O out of 1 checks passed. Review the results below for more details.ERROR 1064 (42000) at line 2: You have an error in your SQL syntax; check the manual that corresponds toyour MYSQL server version for the right syntax to use near 'int DRIVERID) RETURNS VARCHAR BEGIN DECLARE//to store number of travels Count' at line 1ChecksSQL Database Test • Incomplete>Create the DRIVER_STATUS function

Answered: The Driver Relationship team wants to…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Task 2:

The Driver Relationship team wants to arrange workshops and education materials to the drivers. However, the team wants to create clusters of the drivers based on their experience in InstantStay. To collect these detail, you will need to create a SQL function called DRIVER_STATUS to determine the level of the driver as follows:

MASTER: more than 4 travels
PRO: more than 2 travels
ROOKIE: 2 or less travels

In addition, run the function to verify it works as expected and send them back the driver levels.

Task: Create the DRIVER_STATUS function to create clusters of drivers based on experience.

THIS CODE YOU SEE HERE IS WRONG. THERE IS AN ERROR AT LINE 2

DELIMITER <

CREATE FUNCTION DRIVER_STATUS(int DRIVERID)

RETURNS VARCHAR

BEGIN

DECLARE

//to store number of travels

Count int;

//to store level

Level VARCHAR;

//Selects according to passed value

SELECT COUNT(*) INTO Level FROM TRAVEL WHERE DRIVER_ID = DRIVERID;

//returns level

IF( Count > 4) THEN

RETURN "MASTER";

ELSE IF (Count > 2) THEN

RETURN "PRO"

ELSE IF (Count <= 2) THEN

RETURN "ROOKIE";

END

DELIMITER ;

DRIVER_ID
DRIVER_FIRST_NAME DRIVER_LAST_NAME DRIVER_DRIVING_LICENSE_ID
DRIVER_START_DATE DRIVER_DRIVING_LICENSE_CHECKED
DRIVER_RATING
2001
Willie
Butler
1874501
2019-09-12
1
4.4
2002
Justin
Howard
1953853
2019-09-09
1
4.8
2003
Anthony
Walker
1735487
2019-09-15
1
3.5
2004
Ece
Yilmaz
1734747
2019-08-15
1

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions