Write a SQL query to find the top 5 testers who submitted the most validated bugs in the last quarter for Applause.
Use the provided tester and bug records. Consider the last quarter relative to the current date.
tester_name and validated_bug_count.validated_bug_count descending, then tester_name ascending for ties, and return at most five rows.| Column | Type | Description |
|---|---|---|
| tester_idPK | INT | Unique identifier for the tester |
| tester_name | VARCHAR(100) | Display name of the tester |
| Column | Type | Description |
|---|---|---|
| bug_idPK | INT | Unique identifier for the bug submission |
| tester_id | INT | Tester who submitted the bug |
| submitted_at | DATE | Date the bug was submitted |
| validation_status | VARCHAR(30) | Validation state of the submitted bug |