Same-Day Repair Rate by Logged Date

Problem

Table: `repair_ticket`

| Column Name | Type |
|---|---|
| ticket_id | int |
| device_id | int |
| logged_date | date |
| fixed_date | date |

`ticket_id` is the primary key. A ticket is a *same-day repair* when its `fixed_date` equals its `logged_date`.

For each distinct `logged_date`, compute the percentage of tickets logged that day that were same-day repairs. Round the percentage to 2 decimal places and alias it `same_day_rate`. Output `logged_date` and `same_day_rate`, ordered by `logged_date`.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 2 rows with the columns logged_date, same_day_rate.

Starter code (SQL)

SELECT *
FROM repair_ticket;

Related SQL questions

• 3-Day Tweet Rolling AverageMedium
• 7-Day vs 28-Day Rolling Avg DivergenceMedium
• A/B Test Sample Ratio Mismatch (SRM) CheckMedium
• Accounts Streaming From Two Devices at OnceMedium
• Ad Campaign Funnel AnalysisMedium
• Agent Resolution RateMedium