Task 4: The InstantRide Driver Relationship team wants to create groups for drivers according to their ratings such as 3+ or 4+. For instance, a driver with the rating 3.8 will be 3+ ; whereas a...



Task 4:


The InstantRide Driver Relationship team wants to create groups for drivers according to their ratings such as 3+ or 4+. For instance, a driver with the rating3.8 will be3+; whereas a driver with the rating4.2 will be4+. You need to return a two column output withDRIVER_ID andDRIVER_RATING which has first FLOOR applied and then CONCAT with + sign for all drivers with a rating greater than0.




Task: Create groups of drivers according to their ratings. (SQL Database Test)


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

Extracted text: 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
TRAVEL_ID<br>TRAVEL_START_TIME<br>TRAVEL_END_TIME<br>TRAVEL_START_LOCATION<br>TRAVEL_END_LOCATION<br>TRAVEL_PRICE<br>DRIVER_ID<br>CAR_ID<br>USER ID<br>TRAVEL_DISCOUNT<br>5001<br>2019-10-01 04:04:55<br>2019-10-01 04:14:19<br>9614 York Road<br>84 Church Lane<br>15.44<br>2001<br>1003<br>3005<br>NULL<br>5002<br>2019-10-01 05:57:33<br>2019-10-01 06:12:33<br>47 Church Street<br>68 High Street<br>20.56<br>2001<br>1003<br>3006<br>NULL<br>5003<br>2019-10-01 13:35:20<br>2019-10-01 13:45:10<br>2 Windsor Road<br>95 West Street<br>12.32<br>2002<br>1001<br>3002<br>NULL<br>5004<br>2019-10-02 08:44:48<br>2019-10-02 09:15:28<br>9060 Mill Lane<br>27 Main Road<br>30.49<br>2003<br>1002<br>3001<br>0.13<br>5005<br>2019-10-02 16:38:54<br>2019-10-02 16:48:10<br>2 Queensway<br>24 Mill Lane<br>11.15<br>2001<br>1003<br>3007<br>NULL<br>5006<br>2019-10-03 19:12:14<br>2019-10-03 19:23:45<br>50 Main Road<br>93 Broadway<br>14.61<br>2003<br>1002<br>3007<br>0.10<br>5007<br>2019-10-03 16:06:36<br>2019-10-03 16:08:56<br>39 Park Road<br>91 West Street<br>4.41<br>2002<br>1004<br>3003<br>0.14<br>5008<br>2019-10-03 17:17:12<br>2019-10-03 17:37:42<br>37 The Drive<br>17 Stanley Road<br>25.12<br>2001<br>1003<br>3001<br>0.25<br>5009<br>2019-10-03 21:16:48<br>2019-10-03 21:26:18<br>77 Mill Road<br>724 Springfield Road<br>13.55<br>2001<br>1003<br>3005<br>NULL<br>5010<br>2019-10-03 23:21:40<br>2019-10-03 23:39:10<br>16 Church Road<br>30 North Road<br>25.62<br>2003<br>1002<br>3003<br>0.20<br>

Extracted text: TRAVEL_ID TRAVEL_START_TIME TRAVEL_END_TIME TRAVEL_START_LOCATION TRAVEL_END_LOCATION TRAVEL_PRICE DRIVER_ID CAR_ID USER ID TRAVEL_DISCOUNT 5001 2019-10-01 04:04:55 2019-10-01 04:14:19 9614 York Road 84 Church Lane 15.44 2001 1003 3005 NULL 5002 2019-10-01 05:57:33 2019-10-01 06:12:33 47 Church Street 68 High Street 20.56 2001 1003 3006 NULL 5003 2019-10-01 13:35:20 2019-10-01 13:45:10 2 Windsor Road 95 West Street 12.32 2002 1001 3002 NULL 5004 2019-10-02 08:44:48 2019-10-02 09:15:28 9060 Mill Lane 27 Main Road 30.49 2003 1002 3001 0.13 5005 2019-10-02 16:38:54 2019-10-02 16:48:10 2 Queensway 24 Mill Lane 11.15 2001 1003 3007 NULL 5006 2019-10-03 19:12:14 2019-10-03 19:23:45 50 Main Road 93 Broadway 14.61 2003 1002 3007 0.10 5007 2019-10-03 16:06:36 2019-10-03 16:08:56 39 Park Road 91 West Street 4.41 2002 1004 3003 0.14 5008 2019-10-03 17:17:12 2019-10-03 17:37:42 37 The Drive 17 Stanley Road 25.12 2001 1003 3001 0.25 5009 2019-10-03 21:16:48 2019-10-03 21:26:18 77 Mill Road 724 Springfield Road 13.55 2001 1003 3005 NULL 5010 2019-10-03 23:21:40 2019-10-03 23:39:10 16 Church Road 30 North Road 25.62 2003 1002 3003 0.20
Jun 08, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here