Write an SQL query to find the top 5 users by number of searches in the last 30 days.
Use the provided users and searches tables. Treat the last 30 days as the period beginning on CURRENT_DATE - INTERVAL '30 days', inclusive.
user_id, user_name, and search_count.search_count descending, then user_id ascending to break ties.| Column | Type | Description |
|---|---|---|
| user_idPK | INT | Unique user identifier |
| user_name | VARCHAR(100) | Display name of the user |
| Column | Type | Description |
|---|---|---|
| search_idPK | INT | Unique search event identifier |
| user_id | INT | User who performed the search |
| searched_at | DATE | Date when the search occurred |
| query_text | VARCHAR(255) | Text entered for the search |