Question: You are given the data for Uber drivers. It contains their ID , starting date, end date and the yearly salary. For drivers who are
You are given the data for Uber drivers. It contains their ID starting date, end date and the yearly salary. For drivers who are no longer associated with Uber, the data has the end date. For others who are still working with Uber, the column 'enddate' is empty. Identify the yearoveryear fluctuations in the driver attrition rate for Uber. For each year, record the number of drivers who left the platform, as well as the number from the preceding year. Additionally, indicate whether there has been an increase, decrease, or no change in driver churn between these two consecutive years. Output Order of Columns are year, churned, churnedprev, case year: This column represents the year for which the churned driver data is being reported. churned: This column represents the number of drivers who churned left the platform in the Current year. churnedprev: It provides the count of drivers who left Uber in the year before the current year. case: This column represents the categorization of the trend in driver churn between the current year and the previous year. It can take one of the following values: 'increase':Indicates that there was an increase in the number of drivers who churned from the previous year to the current year. 'decrease': Indicates that there was a decrease in the number of drivers who churned from the previous year to the current year. no change': Indicates that the number of drivers who churned remained the same from the previous year to the current year.
Tables Schema as Below:
Uber
columnName dataType
idx INTEGER
startdate DATETIME
enddate DATETIME
yearlysalary INTEGER
Input
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
