The InstantRide Driver Relationship team wants to analyze the travel information of the low rated drivers. You will need to provide them with all the travel information of the drivers with the average rating lower than4. The team wants to get in touch with the travelers and analyze their feedback. You need to runSELECT query and return all travel data from TRAVELS table filtered by the drivers who has lower rating than4 in the DRIVERS table.
Task:
Analyze travel data for the low rated drivers. (SQL Database Test)
You need to first create a subquery to find drivers with rating lower than4. Then you need to use these drivers to find their travels in TRAVELS table:
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here