Authors Who Read Themselves
Authors Who Read Themselves
Find every author who viewed at least one of their own articles. Return the id column sorted in ascending order.
In Views, author_id and viewer_id identify the same people: an author viewed their own article when their identifier appears in both fields.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables. Your answer must use the same column names as this sample — alias them with AS if needed.
| id |
|---|
| 1 |
| 2 |
| 3 |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid