Write a SQL query to find users who commented on their own posts within twenty-four hours of publishing.
Use the users, posts, and comments tables. Treat comments made exactly twenty-four hours after publication as qualifying.
user_id, username, and qualifying_comment_count.user_id ascending.| Column | Type | Description |
|---|---|---|
| user_idPK | INT | Unique user identifier |
| username | VARCHAR(100) | User's display name |
| Column | Type | Description |
|---|---|---|
| post_idPK | INT | Unique post identifier |
| user_id | INT | User who published the post |
| published_at | TIMESTAMPTZ | Post publication timestamp |
| Column | Type | Description |
|---|---|---|
| comment_idPK | INT | Unique comment identifier |
| post_id | INT | Post receiving the comment |
| user_id | INT | User who authored the comment |
| created_at | TIMESTAMPTZ | Comment creation timestamp |