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. SQL Database Test:SELECT DRIVER_ID, DRIVER_STATUS(DRIVER_ID) FROM DRIVERSCreate the DRIVER_STATUS function Expected Results:DRIVER_IDDRIVER_STATUS(DRIVER_ID)2001MASTER2002ROOKIE2003PRO2004ROOKIE2005ROOKIE

Here we have given the solution for the question on driver levels. you can find solution in step 2.

Answered: Task 2: The Driver Relationship team…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

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.

SQL Database Test:

SELECT DRIVER_ID, DRIVER_STATUS(DRIVER_ID) FROM DRIVERS

Create the DRIVER_STATUS function

Expected Results:

DRIVER_ID	DRIVER_STATUS(DRIVER_ID)
2001	MASTER
2002	ROOKIE
2003	PRO
2004	ROOKIE
2005	ROOKIE

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-engineering and related others by exploring similar questions and additional content below.

Similar questions