User Experience Percentage
Start Timer
0:00:00
Given a table called user_experiences, write a query to determine the percentage of users that held the title of "Data Analyst" immediately before holding the title "Data Scientist".
Immediate is defined as the user holding no other titles between the "Data Analyst" and "Data Scientist" roles.
Example:
Input:
user_experiences table
| Column | Type |
|---|---|
id |
INTEGER |
position_name |
VARCHAR |
start_date |
DATETIME |
end_date |
DATETIME |
user_id |
INTEGER |
Output:
| Column | Type |
|---|---|
percentage |
FLOAT |
Recommended questions for you
Personalized based on your user activity, skill level, and preferences.
.
.
.
.
.
.
.
.
.
Comments