Entry-Level Attrition Trend Analysis

I already have the raw HR analytics dataset from Kaggle sitting in a MySQL database, populated each time my existing Python ETL script runs. The broad pipeline works; now I want to drill down on one thing only: how entry-level attrition is evolving over time.

Here’s what I need from you:

• A clean, well-commented SQL query (or set of queries) that calculates monthly and quarterly attrition rates for entry-level employees.
• A short Python (pandas) routine that executes those queries, pushes the results to an Excel file, and time-stamps each export so historical runs are preserved.

Acceptance criteria
1. SQL returns the correct counts and percentages when spot-checked against sample rows in MySQL.
2. The Python script runs from the command line without manual edits, captures the latest data, and drops the finished Excel report into a designated /reports folder.
3. Column names and date formats in the Excel sheet match my existing reporting style (I’ll share a template).

The database connection string, table schema, and my current ETL code will be provided as soon as we start. This is a focused task—just entry-level, just attrition rates over time—so clarity and accuracy matter more than flashy dashboards.