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 'end_date' is empty. Identify the year-over-year 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, churned_prev, 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. -churned_prev: 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
start_date DATETIME
end_date DATETIME
yearly_salary INTEGER
Input

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!