language is mysql

Module 7 Activity 2 Instructions Page 3 of 3 query.sql 1 Write 2 select ols Task 4: 3 FROM DRI 4 LEFT JOI 5 6 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 driver with the rating 4.2 will be 4+. You need to return a two column output with DRIVER_ID and DRIVER_RATING which has first FLOOR applied and then CONCAT with + sign for all drivers with a rating greater than 0. 7 000 10 Task Create groups of drivers according to their ratings. > Task 5: The InstantRide User Satisfaction team are looking forward to creating discounts for the users. However, the team suspects that there could be duplicate users in the system with different emails. Check for the users with their names and surnames for potential duplicates. Therefore, you need to join the USERS table with USERS table and compare for equality of USER_FIRST_NAME and USER_LAST_NAME and difference in USER_ID fields. Task Check for duplicate driver accounts. > SQL Vien