Write a SQL query using window functions to identify the top three repeating service issues by home appliance category for Cinch Home Services.
Use completed service requests only. Exclude requests without a valid appliance category or issue, and break equal-count ties alphabetically by issue name.
Output
- One row per qualifying issue and appliance category.
- Columns:
category_name, issue_name, repeat_count, and issue_rank.
- Include only the top three issues within each category, ordered by category name, rank, and issue name.
