Termination survey data
Question
Given this table here, can you write a SQL query to pull the average and median time by position between:
- "Role Start Date" and "DETE Start Date"
- "Role Start Date" and "Cease Date"
For this exercise, you can replace the spaces with underscores for the field names and you can name the table 'TerminationSurvey'. Lastly, if there's a "Not Started" in any of the date data, you can exclude it.