Write a SQL query to identify the top three industries with the highest employee turnover rate over the last calendar year at Revelio Labs.
Use the provided industry and quarterly workforce metric data. Calculate turnover rate as total separations divided by average headcount during the year.
industry_name, total_separations, average_headcount, and turnover_rate.turnover_rate descending, breaking ties by industry_name ascending.| Column | Type | Description |
|---|---|---|
| industry_idPK | INT | Unique industry identifier |
| industry_name | VARCHAR(100) | Industry name |
| Column | Type | Description |
|---|---|---|
| metric_idPK | INT | Unique workforce metric record identifier |
| industry_id | INT | Industry associated with the workforce metrics |
| metric_month | DATE | Month represented by the workforce metric |
| average_headcount | DECIMAL(12,2) | Average employee headcount for the period |
| separations | INT | Number of employee separations during the period |