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.

Solution

Access restricted

Subscribe to premium account to see the solution.

Get premium now